MS SQL Server MSEQ - Remove letters in column

Author

Remove letters in column

DCR

2005-05-18, 8:26 pm

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
Dave

Hugo Kornelis

2005-05-19, 8:24 pm

On Wed, 18 May 2005 16:28:01 -0700, DCR wrote:

>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
>Dave

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
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Sponsored Links