Efficient ISNUMERIC() replacements on SQL Server?

by

You can use the T-SQL functions TRY_CAST() or TRY_CONVERT() if you’re running SQL Server 2012 as Bacon Bits mentions in the comments:

SELECT CASE WHEN TRY_CAST('foo' AS INT) IS NULL THEN 0 ELSE 1 END

SELECT CASE WHEN TRY_CAST(1 AS INT) IS NULL THEN 0 ELSE 1 END

If you’re using SQL 2008 R2 or older, you’ll have to use a .NET CLR function, and wrap System.Decimal.TryParse().

More Related Contents:

  1. How to strip all non-alphabetic characters from string in SQL Server?
  2. T-sql – determine if value is integer
  3. how to write number to word function in sql server [closed]
  4. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  5. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  6. Does query plan optimizer works well with joined/filtered table-valued functions?
  7. How to get the last row from a table in SQL Server?
  8. Storing a file in a database as opposed to the file system?
  9. Preferred Method of Storing Passwords In Database
  10. How do you count the number of occurrences of a certain substring in a SQL varchar?
  11. Why is it considered bad practice to use cursors in SQL Server?
  12. Pass table as parameter into sql server UDF
  13. Import Excel spreadsheet columns into SQL Server database
  14. Find index of last occurrence of a sub-string using T-SQL
  15. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  16. SQL Server 2008 Empty String vs. Space
  17. SQL Query to find the last day of the month
  18. How do I list all tables in all databases in SQL Server in a single result set?
  19. How do I copy SQL Azure database to my local development server?
  20. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  21. SQL Server 2008 Vertical data to Horizontal
  22. Joining multiple tables returns NULL value
  23. Which join syntax is better?
  24. How to maintain the order of insertion in SQL Server
  25. What are the differences between Merge Join and Lookup transformations in SSIS?
  26. Table Valued Function Killing My Query Performance
  27. freeTDS not using its config
  28. @@ERROR and/or TRY – CATCH
  29. How to make a passthrough / passthru query editable?
  30. How to do Sql Server CE table update from another table

Leave a Comment