Hi

I have a basic question
I am using SQL command/query like
"INSERT INTO table1 (FName) VALUES (' " & sStr & " ' )"
If sStr (the string) contain the char " ' " then I get an error
I understand why it happened but I need a way around it

Thanks
Limor