MSSQL Regular expression

by

This is what I have used in the end:

SELECT *, 
  CASE WHEN [url] NOT LIKE '%[^-A-Za-z0-9/.+$]%' 
    THEN 'Valid' 
    ELSE 'No valid' 
  END [Validate]
FROM 
  *table*
  ORDER BY [Validate]

More Related Contents:

  1. Best equivalent for IsInteger in SQL Server
  2. Perform regex (replace) in an SQL query
  3. How to extrapolate dates in SQL Server to calculate the daily counts?
  4. Difference between JOIN and INNER JOIN
  5. Is there a way to access the “previous row” value in a SELECT statement?
  6. Remove Identity from a column in a table
  7. How to create multiple one to one’s
  8. efficient way to implement paging
  9. SQL Server – transactions roll back on error?
  10. Formatting Numbers by padding with leading zeros in SQL Server
  11. Difference between a User and a Login in SQL Server
  12. SQL Server : dynamic pivot over 5 columns
  13. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  14. Postgres Case Sensitivity
  15. How do I query for all dates greater than a certain date in SQL Server?
  16. Check If the string contains accented characters in SQL?
  17. Count based on condition in SQL Server
  18. Does Sql JOIN order affect performance?
  19. What does sp_reset_connection do?
  20. Syntax of for-loop in SQL Server
  21. Replace first occurrence of substring in a string in SQL
  22. Why does ISNUMERIC(‘.’) return 1?
  23. How to correctly insert newline in nvarchar [duplicate]
  24. How do you copy a record in a SQL table but swap out the unique id of the new row?
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. How do I list all the columns in a table?
  27. SQL UPDATE TOP with ORDER BY?
  28. How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?
  29. Convert bigint to datetime
  30. SQL SERVER DATETIME FORMAT

Leave a Comment