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 |
|
Madhav
Starting Member
38 Posts |
 Posted - 2010-02-13 : 12:16:07
|
| HiI have a column "User_Name" in table "User". User_name column has special characters like "ö" and other language characters like chinese/japanese characters. I want to find all the rows which have these special characters. Can any one help with a query??Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-13 : 12:30:52
|
| I think one way may be to look for presence of those characters using their ascii values------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Madhav
Starting Member
38 Posts |
Posted - 2010-02-13 : 14:13:53
|
quote:
Originally posted by visakh16
I think one way may be to look for presence of those characters using their ascii values
ASCII function checks only for single character(Left most character of the expression) and returns ASCII code. But how to check other characters apart from left most character?? Is there any direct query find special characters??Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-14 : 03:52:17
|
quote:
Originally posted by Madhav
quote:
Originally posted by visakh16
I think one way may be to look for presence of those characters using their ascii values
ASCII function checks only for single character(Left most character of the expression) and returns ASCII code. But how to check other characters apart from left most character?? Is there any direct query find special characters??Thanks
Nope you need to loop over the strings to check character by character for finding presence of other language characters------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
How to find chinese/japanese characters in a table