How to detect if a string contains special characters?

by

Assuming SQL Server:

e.g. if you class special characters as anything NOT alphanumeric:

DECLARE @MyString VARCHAR(100)
SET @MyString = 'adgkjb$'

IF (@MyString LIKE '%[^a-zA-Z0-9]%')
    PRINT 'Contains "special" characters'
ELSE
    PRINT 'Does not contain "special" characters'

Just add to other characters you don’t class as special, inside the square brackets

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. SQL QUERY COUNT THEN ADD
  3. SQL server command help and tutorials for specific commands?
  4. Making a dynamic pivot table but without using the fiddle
  5. Get top 1 row of each group
  6. How to return only the Date from a SQL Server DateTime datatype
  7. Referring to a Column Alias in a WHERE Clause
  8. Convert Datetime column from UTC to local time in select statement
  9. How to implement LIMIT with SQL Server? [duplicate]
  10. Why is SQL Server losing a millisecond?
  11. converting Epoch timestamp to sql server(human readable format)
  12. What are Covering Indexes and Covered Queries in SQL Server?
  13. How do I split a delimited string so I can access individual items?
  14. What’s the best way to select the minimum value from several columns?
  15. Add a summary row with totals
  16. T-SQL split string based on delimiter
  17. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  18. Why use Select Top 100 Percent?
  19. How do I find duplicates across multiple columns?
  20. Calculate business hours between two dates
  21. Correct use of transactions in SQL Server
  22. SQL Server UNION – What is the default ORDER BY Behaviour
  23. store arabic in SQL database
  24. What is the Null Character literal in TSQL?
  25. how does SELECT TOP works when no order by is specified?
  26. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  27. How do I find the data directory for a SQL Server instance?
  28. How to update rows with a random date
  29. How do I compare two columns for equality in SQL Server?
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment