Tag: Tables
-
Replacing first occurrence of certain characters in MSSQL database
This post is regarding how to replace first occurrence of one or more characters from database table Column. Suppose we have table named User with columns Id, Name, Phone Number as shown in the figure below. And contains records as shown in figure below: Now what I required to accomplish is replace the first ‘-‘…