What we can use Instead of Replace

Pinku

7y857

SELECT COUNT(ResumeDID) FROM resumedata.dbo.reportedResumefeedback WITH(NOLOCK) WHERE REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE( REPLACE( REPLACE(SeekerPhone, '+1', '' ), '+5', '' ), ')', '' ), '-', '' ), '.', '' ), ' ', '' ), '/', '' ), '=', ''), '+6', ''), '(', ''),'x', ''),'et', '') = '" + PhoneNumber + "'"

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nigel Fernandes7y ago
Accepted answer
//TRY THIS

CREATE FUNCTION dbo.GetCharacters(@myString varchar(500), @validChars varchar(100))
RETURNS varchar(500) AS
BEGIN
While @myString like '%[^' + @validChars + ']%'
Select @myString = replace(@myString,substring(@myString,patindex('%[^' + @validChars + ']%',@myString),1),'')
Return @myString
END
Go

Select dbo.GetCharacters('Input','0-9');

Copied from :
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7044fab9-bdb2-4f54-98ed-7bcbaca3e648/how-to-remove-special-characters-in-a-particular-column?forum=transactsql
0
Pinku7y ago
How to use regex in this code instead of replace
0
Nigel Fernandes7y ago
Hi what are you trying to achieve ? trying to remove special characters?
Then maybe you want to try regex?
0