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

Related Contents:

  1. Select statement to find duplicates on certain fields
  2. T-SQL Cast versus Convert
  3. Convert Datetime column from UTC to local time in select statement
  4. When to use Common Table Expression (CTE)
  5. How do I create a foreign key in SQL Server?
  6. Inserting data into a temporary table
  7. Change Schema Name Of Table In SQL
  8. How to calculate age (in years) based on Date of Birth and getDate()
  9. Why does using an Underscore character in a LIKE filter give me all the results?
  10. How do I drop table variables in SQL-Server? Should I even do this?
  11. Getting result of dynamic SQL into a variable for sql-server
  12. How to assign an exec result to a sql variable?
  13. Is there a way to list open transactions on SQL Server 2000 database?
  14. How to print GETDATE() in SQL Server with milliseconds in time?
  15. SQL Row_Number() function in Where Clause
  16. How to copy a row from one SQL Server table to another
  17. How do you update a DateTime field in T-SQL?
  18. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  19. SQL Server Invalid Column name after adding new column
  20. Get Table and Index storage size in sql server
  21. Create parameterized VIEW in SQL Server 2008
  22. SQL Join Table Naming Convention [closed]
  23. What is the equivalent of the Oracle “Dual” table in MS SqlServer?
  24. Using tuples in SQL “IN” clause
  25. Inner Joining three tables
  26. SQL Server: IF EXISTS ; ELSE
  27. SQL Server find and replace specific word in all rows of specific column
  28. How to select data of a table from another database in SQL Server?
  29. How do I determine if a database role exists in SQL Server?
  30. Postgres Case Sensitivity
  31. My Select SUM query returns null. It should return 0
  32. What’s the SQL national character (NCHAR) datatype really for?
  33. DateTimeOffset.Now in T-SQL
  34. SQL DATEPART(dw,date) need monday = 1 and sunday = 7
  35. How do you strip a character out of a column in SQL Server?
  36. Using DISTINCT and TOP in the same query
  37. SQL: How do I use parameter for TOP like in SELECT TOP @amount? [duplicate]
  38. SQL server identity column values start at 0 instead of 1
  39. SQL Server Count is slow
  40. Arithmetic overflow error when summing an INT, how do I cast it as a BIGINT?
  41. How to create table using select query in SQL Server?
  42. Trim spaces in string – LTRIM RTRIM not working
  43. SQL, How to Concatenate results?
  44. How do I list user defined types in a SQL Server database?
  45. How can I see all the “special” characters permissible in a varchar or char field in SQL Server? [closed]
  46. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?
  47. Debugging stored procedures in SQL Server Management Studio
  48. SQL Server Left Join With ‘Or’ Operator
  49. In SQL Azure how can I create a read only user
  50. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?

Leave a Comment