Sql Server: Isolating particular character?

Char' UNION ALL SELECT N'funky � char' SELECT * FROM #stories WHERE body like '%�%' SELECT * FROM #stories WHERE body like N'%�%' COLLATE Latin1_General_BIN2 DROP TABLE #stories.

Perfect. And it looks like this update statement will do the job: update #stories set body = Replace(body, N'�'COLLATE Latin1_General_BIN2, ' ') WHERE body like N'%�%' COLLATE Latin1_General_BIN2 – Dzejms May 4 at 15:22.

I'm running SQL Server 2008 R2. There are a number of records that have this funky � character in a particular column. I'd like to isolate just those records and do a Replace() on them.

It will return stories where the � isn't in the body column.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions