Varsha

• Dec 8th, 2011

 

This can be done by using the TRANSLATE function as it replaces character by character.

Swathy

• Dec 12th, 2011

 

Varsha could you please write the query for this above question?

kirathakudu

 Profile Answers by kirathakudu 

• Dec 13th, 2011

 

translate(PHONE,[a,b,c,d,e,f..etc],SPACE)

where ever there is an alphabet it will be replaced by space

eg:

PHONE = 32663cdefh3456
after translate PHONE = 32663 3456

translate( string1, string_to_replace, replacement_string )

sanjay

• Jan 5th, 2012

 

Code
 

sriram

• Feb 24th, 2012

 

Code
 

naga

• Mar 12th, 2012

 

Code
 

Abhishek

• Aug 23rd, 2012

 

Code
span style="color: #808080; font-style: italic;">#temp FROM dbo.numeric


#temp


#temp)


#temp)


--inner loop ends


#temp


#temp)


--outer while loop 


#temp

stalinK

• Jul 23rd, 2014

 

Code
 

pradipta

 Profile Answers by pradipta 

• Jul 28th, 2014

 

SELECT REGEXP_REPLACE(COL_NAME, ([a-z]|[A-Z]), ) FROM TBL_NAME ;

stalink

• Sep 22nd, 2014

 

DECLARE @Temp VARCHAR(100)=(StalinKIN095815)
Declare @NumRange as varchar(50) = %[0-9]%
While PatIndex(@NumRange, @Temp) > 0
Set @Temp = Stuff(@Temp, PatIndex(@NumRange, @Temp), 1, )

SELECT @Temp

rajesh anasuri

• Sep 3rd, 2015

 

SELECT REGEXP_REPLACE(AB12CD34EF,[A-Z], ) FROM DUAL ;

Krishna

• Mar 30th, 2016

 

Code
 

Ganezh

• Apr 20th, 2016

 

Code