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 |
|
donpolix
Yak Posting Veteran
97 Posts |
 Posted - 2005-06-09 : 07:26:45
|
| If I have a field with type nvarchar(4000), I want to query this field so that if the data contains any double byte characters, it will return 'NON ENGLISH CHARS'. for example: fieldname = MessageFieldMessageField--------------asdfq werrtu im äµ�¬äŽz2xcv asdf12 ‹X . helloI want to return it this way:MessageField--------------asdfq wer'NON ENGLISH CHARS'z2xcv asdf'NON ENGLISH CHARS'Appreciate any help on this. Thanks!Donn Policarpio |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-09 : 07:38:25
|
| Please do not cross post [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50912[/url]JimUsers <> Logic |
 |
|
|
|
|
|
determine if a string contains doublebyte chars