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
SELECT REPLACE(TRANSLATE(909090abc4567d,a,b,c,d,e,f,g, ), ,) FROM dual

sriram

• Feb 24th, 2012

 

Code
SELECT columnname FROM tablename WHERE regexp_like(columnname,^[[:digit:]]+$) ;

naga

• Mar 12th, 2012

 

Code
SELECT REPLACE(TRANSLATE(LOWER(99sAmn44423mz44),abcdefghijklmnopqrstuvwxyz, ), ,) FROM dual 

Abhishek

• Aug 23rd, 2012

 

Code
declare  @temp_numeric TABLE (value nvarchar(500)) 


declare @i int=1,@len int,@ans nvarchar(100)=,@str nvarchar(100)


DECLARE @count INT


 


SELECT VALUE INTO #temp FROM dbo.numeric


 


SELECT * FROM #temp


 


SET @count=(SELECT COUNT(*) FROM dbo.#temp)


WHILE(@count>0)


BEGIN


 


 


SET @str = (SELECT TOP (1) value FROM #temp)


 


SET @len=(SELECT LEN(@str))


 


while(@i<=@len)


 BEGIN


     


  IF(isnumeric(SUBSTRING(@str,@i,1))=1)


  begin


  SET @ans=@ans+(SELECT SUBSTRING(@str,@i,1))


  end


  SET @i=@i+1


 


 END --inner loop ends


 


DELETE TOP(1) FROM #temp


SET @count=(SELECT COUNT(*) FROM #temp)


 


 INSERT INTO @temp_numeric VALUES(@ans)


 


 SET @i=1


 SET @ans=


END --outer while loop 


 


 


 SELECT * FROM @temp_numeric


 


 DROP TABLE #temp

stalinK

• Jul 23rd, 2014

 

Code
DECLARE @Temp VARCHAR(100)=(STA123LIN)


Declare @NumRange AS varchar(50) = %[0-9]%


    While PatIndex(@NumRange, @Temp) > 0


        SET @Temp = Stuff(@Temp, PatIndex(@NumRange, @Temp), 1, )


 


SELECT @Temp

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
SELECT REGEXP_REPLACE(<Column Name>,[A-Za-z]) FROM <Table Name>;

Ganezh

• Apr 20th, 2016

 

Code
SELECT REGEXP_REPLACE(AB12CD34EF,A|B|C|D|E|F, ) FROM DUAL;