how to replace string value in sql query
|
Smith
2942
Points
79
Posts
|
Answers
|
Brian
2470
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
|
Blog
Active User (13)
