How to get the numeric part from a string using T-SQL?

by 
select left(@str, patindex('%[^0-9]%', @str+'.') - 1)

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  3. Should I use != or for not equal in T-SQL?
  4. How to update two tables in one statement in SQL Server 2005?
  5. Conversion failed when converting date and/or time from character string while inserting datetime
  6. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  7. Foreign Key to non-primary key
  8. Difference between left join and right join in SQL Server [duplicate]
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. Creating table names that are reserved words/keywords in MS SQL Server [closed]
  11. Dynamic SQL – EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
  12. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  13. Get all dates between two dates in SQL Server
  14. Run all SQL files in a directory
  15. Rename column SQL Server 2008
  16. Compare DATETIME and DATE ignoring time portion
  17. Fastest way to determine if record exists
  18. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  19. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  20. Selecting first row per group
  21. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  22. SQL Server Convert integer to binary string
  23. How to find column names for all tables in all databases in SQL Server
  24. SQL update trigger only when column is modified
  25. Passing dynamic order by in stored procedure
  26. How do I compare 2 rows from the same table (SQL Server)?
  27. How do I change db schema to dbo
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. How to get the next number in a sequence
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment