Remove numbers from string sql server

by

1st option –

You can nest REPLACE() functions up to 32 levels deep. It runs fast.

REPLACE
(REPLACE
(REPLACE
(REPLACE
(REPLACE
(REPLACE
(REPLACE
(REPLACE
(REPLACE
(REPLACE (@str, '0', ''),
'1', ''),
'2', ''),
'3', ''),
'4', ''),
'5', ''),
'6', ''),
'7', ''),
'8', ''),
'9', '')

2nd option —
do the reverse of –

Removing nonnumerical data out of a number + SQL

3rd option – if you want to use regex

then
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27205

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. CROSS JOIN vs INNER JOIN in SQL
  3. How to cast the DateTime to Time
  4. How can I schedule a job to run a SQL query daily?
  5. How to generate a range of numbers between two numbers?
  6. Reset identity seed after deleting records in SQL Server
  7. How to avoid the “divide by zero” error in SQL?
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. Real life example, when to use OUTER / CROSS APPLY in SQL
  10. How to update Identity Column in SQL Server?
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. Concatenate values based on ID
  14. SQL Server 2008: how do I grant privileges to a username?
  15. How do I find duplicates across multiple columns?
  16. Split values over multiple rows [duplicate]
  17. How to do an inner join on row number in sql server
  18. Execute Dynamic Query with go in sql
  19. TransactSQL to run another TransactSQL script
  20. How can I get a list of element names from an XML value in SQL Server
  21. Stored procedure that exports data into csv files only exports to one file
  22. SQL Server: should I use information_schema tables over sys tables?
  23. How to rename something in SQL Server that has square brackets in the name?
  24. how to separate string into different columns?
  25. TSQL – How to use GO inside of a BEGIN .. END block?
  26. SQL take just the numeric values from a varchar
  27. Select SQL Server database size
  28. Backup a single table with its data from a database in sql server 2008
  29. COALESCE Function in TSQL
  30. Try_Convert for SQL Server 2008 R2

Leave a Comment