DATA HAVING " ' " SINGLE QUOTE

[ankit.jain2 (Ankit Jain)]

i want to insert data into sql express but in some fields data having single quotes … is there any way to insert data with single quotes without using replace or remove like we use in orcale /q for escape special character.

[NIVED_NAMBIAR (NIVED N)]

Hi @ankit.jain2
You can try something like “‘SAMPLE’” for example

[ankit.jain2 (Ankit Jain)]

i try to replace single quote with 3 quotes but its no working

[SHEIK_AASIF]

@ankit.jain2 try this
“'”+text+“'”

[Palaniyappan (Forum Leader)]

Hi

Did we check with this thread with similar scenario

How i can interpret the quotes inside the querry?

I tried to put a name for my columns with spaces, and because of delimitation of the string in the Execute Query activity with “”, it gives me error of the syntax. The querry i want it to process is something like that: Select Column1 as “Column 1”, Column2 as “Column 2” FROM TABLE Please help me with that . Thank you in advance!

Cheers @ankit.jain2