how to replace string value in sql query
|
Smith
2568
Points
74
Posts
|
Answers
|
Brian
2232
Points
14
Posts
|
Hi Smith, Use replace method in sql query as: Syntax REPLACE(<string value>,<string to replace>,'string replace with')
Example SELECT REPLACE(<fieldname>,'XYZ','ABC') FROM <tablename>
SELECT REPLACE('stringvalue','value','')
Posted On:
16-Jun-2015 08:58
|
