Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best method to disallow special characters
Message
From
04/10/2005 14:15:15
 
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
01055902
Message ID:
01055981
Views:
18
>
>IF @StringToTest LIKE '%[[\]!@#$%^&*()\\]%' ESCAPE '\'
>	PRINT 'BAD'
>
>>
>>This works nicely.
>>Is there a way to include ] and ' in the bad list?

Thank you Sergey, as always, your help is very appriciated.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform