SQLServerCentral » Latest topics
Case and replace
Hi,
I have got a number of records that begin with 044, I need to replace that with 0. I am using this replace(cli,'044','0'), however some records are 044123044 and so it replaces the end of the record with 0 also. How can I get it to just
I have got a number of records that begin with 044, I need to replace that with 0. I am using this replace(cli,'044','0'), however some records are 044123044 and so it replaces the end of the record with 0 also. How can I get it to just
No comments:
Post a Comment