Click here to Skip to main content
14,836,622 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all,

I have a column with data containing special characters , So whenever i read data from this column i want the data without special characters i.e only numbers and alphabets to be shown. So can i get any solution to restrict the special characters in sql???
Posted

•_ Any single character.
•[ ] Any single character within the specified range ([a-f]) or set ([abcdef]).
•[^] Any single character not within the specified range ([^a-f]) or set ([^abcdef]).
   
Comments
qwerty 2 26-Jun-12 6:34am
   
Can you explain in detail using the query

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900