Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to select out only the Unicode chars <> 160

Author  Topic 

phrankbooth
Posting Yak Master

162 Posts

Posted - 2013-08-15 : 15:59:22
There's a field that has a string of chars, but one of those chars is Unicode 160 which is bad char.

Without looping, how can I say;

SELECT Field FROM Table WHERE chars in field <> unicode 160

--PhB

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2013-08-15 : 16:09:28
Maybe the REPLACE function?
Go to Top of Page

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-08-16 : 12:47:41
have you tried using LIKE?

djj
Go to Top of Page

ScottPletcher
Aged Yak Warrior

550 Posts

Posted - 2013-08-16 : 18:14:03
Not 100% sure of what you're trying to do, but maybe this?:


SELECT Field
FROM Table
WHERE
field LIKE N'%' + NCHAR(160) + N'%'



Go to Top of Page
   

- Advertisement -