How to get only numeric column values?

by 
SELECT column1 FROM table WHERE ISNUMERIC(column1) = 1

Note, as Damien_The_Unbeliever has pointed out, this will include any valid numeric type.

To filter out columns containing non-digit characters (and empty strings), you could use

SELECT column1 FROM table WHERE column1 not like '%[^0-9]%' and column1 != ''

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. Export from SQL Server to Excel
  3. SQL server query to output the data shown below
  4. hide/remove header and footer
  5. How to use a variable for the database name in T-SQL?
  6. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  7. SQL Server: SELECT only the rows with MAX(DATE)
  8. Create a view with ORDER BY clause
  9. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  10. INSERT INTO vs SELECT INTO
  11. Possible to store value of one select column and use it for the next one?
  12. LEN function not including trailing spaces in SQL Server
  13. How to view transaction logs in SQL Server 2008 [closed]
  14. Scheduled run of stored procedure on SQL server
  15. SQL Server ORDER BY date and nulls last
  16. Best way to implement an audit trail in SQL Server?
  17. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  18. How can I Insert data into SQL Server using VBNet
  19. What happens to the primary key Id when it goes over the limit?
  20. Using NOLOCK Hint in EF4?
  21. Will GETUTCDATE() return the same value if used twice in the same statement?
  22. Convert decimal time to hours and minutes
  23. Remove all spaces from a string in SQL Server
  24. Create table (structure) from existing table
  25. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  26. How can I make SQL Server return FALSE for comparing varchars with and without trailing spaces?
  27. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  28. SQL SERVER – Understanding how MIN(text) works
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment