sql server mseq: I have a column that have numbers & letters combined in a field. What sql
command would remove the letters only, not the numbers?
I have a table called “customer” and the column in that table is called
“customtext4”. I want to change over 5000 records in this “customtext4” field

Thanks for your help

[quoted text, click to view]

Hi Dave,

String manipulation is a weak spot in SQL Server's command set. This can
be done, but it's clumsy:

UPDATE Customer
SET CustomText4 = REPLACE(
REPLACE(
REPLACE(
....
REPLACE(CustomText, 'A', '')
, 'B', '')
, 'C', '')
.....
, 'Z', '')


Best, Hugo
--