Replace numeric string

Tasneem · Post by **Tasneem** » Tue Jan 03, 2006 12:09 am

Hi ,

I have a requirement where I need to trim any numeric occurence in a string.

For eg: "abc2def6rg"
should be made :"abcdefrg"

The length of numeric string at any occurence is variant.
I thought Ereplace function wud help,but for this requirement it is not of much use.

Thanx,

ArndW · Post by **ArndW** » Tue Jan 03, 2006 2:31 am

If you only wish to remove numeric digits from the string, you can do a

Code: Select all

CONVERT('01223456789','',In.String)

. This will strip out the digits 0-9 in your string.