Click here to Skip to main content
15,443,281 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???

•_ 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]).
Share this answer
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