Pinku

Pinku

  • 1.4k
  • 292
  • 44.2k

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)