April 1, 2011 at 3:11 am
Hi All,
I have a SQL Server 2008 database in which users from all over the world put their data.
Now the problem is that the keyboards across the world have different characters & symbols.
We want to remove this characters from our SQL Server Table & keep only the ENGLISH Letters.
Does anyone have the script to do so.
April 1, 2011 at 3:48 am
You can check the characters ASCII by using ASC function and if the value is not between to English chars ASCIIs you can replace it with required values. 65 to 90 capital letters. 97 to 122 small letters. You can check the below link for the list for other char ASCIIs.
_____________________________________________
One ounce of practice is more important than tonnes of dreams
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply