SQL to find first non-numeric character in a string

by

You can use PATINDEX with a pattern like '%[^0123456789]%' or '%[^0-9]%' to find the position of the first non-numeric character

More Related Contents:

  1. Find index of last occurrence of a sub-string using T-SQL
  2. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  3. How do I create a unique constraint that also allows nulls?
  4. How do I get list of all tables in a database using TSQL?
  5. Get first day of week in SQL Server
  6. What is the significance of 1/1/1753 in SQL Server?
  7. Escape a string in SQL Server so that it is safe to use in LIKE expression
  8. Insert Update trigger how to determine if insert or update
  9. SQL time difference between two dates result in hh:mm:ss
  10. What is the best way to truncate a date in SQL Server?
  11. Dynamic SQL (passing table name as parameter)
  12. SQL Server: Difference between PARTITION BY and GROUP BY
  13. How do you truncate all tables in a database using TSQL?
  14. Understanding SQL Server LOCKS on SELECT queries
  15. SQL Server: How to select all days in a date range even if no data exists for some days
  16. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  17. TSQL: How to convert local time to UTC? (SQL Server 2008)
  18. T-SQL Dynamic SQL and Temp Tables
  19. Find non-ASCII characters in varchar columns using SQL Server
  20. How can I determine in SQL Server if a dateTime range overlaps another
  21. SQL Server Query – groupwise multiplication
  22. How do I select last 5 rows in a table without sorting?
  23. SELECT INTO a table variable in T-SQL
  24. T-SQL query to show table definition?
  25. How can I insert binary file data into a binary SQL field using a simple insert statement?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Include missing months in Group By query
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Update SQL with consecutive numbering
  30. Count number of records returned by group by

Leave a Comment