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.
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? |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-08-16 : 12:47:41
|
have you tried using LIKE?djj |
|
|
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'%' |
|
|
|
|
|