how to replace string value in sql query

Smith

2926 Points

78 Posts

Hi,

how to replace string value in sql query in sql server

Views: 8974
Total Answered: 1
Total Marked As Answer: 1
Posted On: 16-Jun-2015 08:39

Share:

Answers

Brian

2438 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

Discussion

MVC Design pattern