>In a table, we have a char column. The data like these:
>
>No. 1349, High Street
>5617 good drive way
>
>We want delete all number in this columns. We want to use Replace functiion, but we can't use range [0-9].
>
>Please help
>
>
>Jim

DECLARE @myString VARCHAR(50)
SELECT @myString='No. 1349, High Street'
-- start : uses a dummy select variable for fill the @@ROWCOUNT
WHILE @@ROWCOUNT>0
   -- uses  the UPDATE table .... where PATINDEX .... here
    select @myString=STUFF(@myString,patindex('%[0-9]%',@myString),1,'') WHERE patindex('%[0-9]%',@myString)>0
--- end
SELECT @myString