Replace function

Vamsi k

7y1.1kSQL

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth7y ago
Hi Vamsi,

Add single quates instead of double quatues.
REPLACE('OCRTYZ-DYZ;D007654',';',',');
Please read my article for more details :

https://www.c-sharpcorner.com/UploadFile/2a6dc5/use-of-replace-function-in-microsoft-sql/
Jignesh Kumar7y ago
Hi Vamsi,

just try this one ''+replace (@value,';',',')+'' instead of ''''+replace (@value,';',''',''')+''''
In your code '''' means it will add ' before and one ' after.