Check if a varchar is a number (T-SQL)

by

ISNUMERIC will not do – it tells you that the string can be converted to any of the numeric types, which is almost always a pointless piece of information to know. For example, all of the following are numeric, according to ISNUMERIC:

£, $, 0d0

If you want to check for digits and only digits, a negative LIKE expression is what you want:

not Value like '%[^0-9]%'

More Related Contents:

  1. Check if a varchar is a number (TSQL)
  2. SQl CASE Statement
  3. How to calculate age in T-SQL with years, months, and days
  4. Convert multiple rows into one with comma as separator [duplicate]
  5. How to get sp_executesql result into a variable?
  6. How can I use optional parameters in a T-SQL stored procedure?
  7. T-SQL Decimal Division Accuracy
  8. Selecting a Record With MAX Value
  9. How to convert Seconds to HH:MM:SS using T-SQL
  10. T-SQL: Selecting rows to delete via joins
  11. Combining INSERT INTO and WITH/CTE
  12. What is a “batch”, and why is GO used?
  13. Getting the minimum of two values in SQL
  14. TSQL divide by zero encountered despite no columns containing 0
  15. T-SQL loop over query results
  16. How to insert default values in SQL table?
  17. How to Round a Time in T-SQL
  18. T-SQL CASE Clause: How to specify WHEN NULL
  19. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  20. Return a value if no rows are found in Microsoft tSQL
  21. Using Aliases in Where Clause or an Alternative Option?
  22. Extract the first word of a string in a SQL Server query
  23. Can I use the MERGE statement in SQL Server 2005?
  24. Search for one value in any column of any table inside a database
  25. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  26. Convert unix epoch timestamp to TSQL datetime
  27. T-SQL Between Dates Confusion
  28. String.Format like functionality in T-SQL?
  29. How to parse string into date?
  30. Stored procedure hangs seemingly without explanation

Leave a Comment