Fastest way to remove non-numeric characters from a VARCHAR in SQL Server

by

I saw this solution with T-SQL code and PATINDEX. I like it 🙂

CREATE Function [fnRemoveNonNumericCharacters](@strText VARCHAR(1000))
RETURNS VARCHAR(1000)
AS
BEGIN
    WHILE PATINDEX('%[^0-9]%', @strText) > 0
    BEGIN
        SET @strText = STUFF(@strText, PATINDEX('%[^0-9]%', @strText), 1, '')
    END
    RETURN @strText
END

More Related Contents:

  1. How do I obtain a Query Execution Plan in SQL Server?
  2. Count(*) vs Count(1) – SQL Server
  3. What is the best way to paginate results in SQL Server
  4. When should I use CROSS APPLY over INNER JOIN?
  5. INNER JOIN vs LEFT JOIN performance in SQL Server
  6. SQL JOIN vs IN performance?
  7. Is a view faster than a simple query?
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. SQL Server indexes – ascending or descending, what difference does it make?
  10. Does Foreign Key improve query performance?
  11. Counting DISTINCT over multiple columns
  12. Fastest way to determine if record exists
  13. SQL count(*) performance
  14. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  15. Why is a UDF so much slower than a subquery?
  16. Favourite performance tuning tricks [closed]
  17. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  18. Can an INNER JOIN offer better performance than EXISTS
  19. How to check which locks are held on a table
  20. SQL Server SELECT LAST N Rows
  21. SQL Server 2008 paging methods?
  22. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  23. When using GETDATE() in many places, is it better to use a variable?
  24. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?
  25. Condition within JOIN or WHERE
  26. Equivalent of Oracle’s RowID in SQL Server
  27. Why can’t I use alias in a count(*) “column” and reference it in a having clause?
  28. How to find third or náµ—Ê° maximum salary from salary table?
  29. sql group by only rows which are in sequence
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment