SQL take just the numeric values from a varchar

by

Here’s the example with PATINDEX:

select SUBSTRING(fieldName, PATINDEX('%[0-9]%', fieldName), LEN(fieldName))

This assumes (1) the field WILL have a numeric, (2) the numerics are all grouped together, and (3) the numerics don’t have any subsequent characters after them.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Is it possible to write single query on two table which are not connected to each other?
  3. CROSS JOIN vs INNER JOIN in SQL
  4. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  5. SET versus SELECT when assigning variables?
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Split function equivalent in T-SQL?
  8. Is the NOLOCK (Sql Server hint) bad practice?
  9. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  10. Where value in column containing comma delimited values
  11. Parse comma-separated string to make IN List of strings in the Where clause
  12. SQL query to split column data into rows
  13. Common Table Expression, why semicolon?
  14. T-SQL split string based on delimiter
  15. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  16. Splitting delimited values in a SQL column into multiple rows
  17. Compare DATETIME and DATE ignoring time portion
  18. Split function in SQL Server 2008
  19. SQL “between” not inclusive
  20. Can I set ignore_dup_key on for a primary key?
  21. Using PIVOT in SQL Server 2008
  22. Stored procedure that exports data into csv files only exports to one file
  23. How do I prevent a database trigger from recursing?
  24. How can I group by date time column without taking time into consideration
  25. How to combine results of two queries into a single dataset
  26. When using GETDATE() in many places, is it better to use a variable?
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. SQL Server SELECT INTO @variable?
  29. Using CASE Statement inside IN Clause
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment