Forums - C# Corner

Forum guidelines
Manas Sahu

Manas Sahu

  • 1.7k
  • 114
  • 1.8k

What we can use Instead of Replace

Apr 23 2019 1:00 AM
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 + "'"

Answers (3)