Hello Everybody!

I`ve got a simple question to you guyz! Is there any way to allow single quotes ( ' ) to be inserted in a SQL string in order to insert a record in my db?

For example if I try to insert the value "john's" an error will occur because the single quote will end the query in my SQL string.

Is there a solution for that prob.? or should I forbid the users entering single quotes with VB script?

Double up the single quotes, so use before doing the insert/update

pgtips thank you for your quick reply and for your helpful tip!

It works great! Thank you!