Vamsi k

Vamsi k

  • NA
  • 296
  • 46.4k

Replace function

Jan 1 2019 11:29 PM

Hi everyone,

I had a doubt in replace function in SQL.
 
In our C# code we are passing 2 values like OCRTYZ-DYZ and D007654 by using concation separting with semicolumn
 OCRTYZ-DYZ;D007654
 
In the Sql script we have written the below replace function to replace the ; to , 

set @val = ''''+replace (@value,';',''',''')+''''

The above all are single quotes. Can anyone please explain what does the above line tells. 
 
 I understood ; is replaced with , but why those single quotes after that , also.
 
Thanks 

Answers (2)