Hi

i am createing a update string such as below
"update __ values ( ' " + var1 +" ' ) ";

but whenever the var1 contains something like this 'tom's ' , the
string contains the extra colon, and the string breaks when i try to
use this command to update to the database.

How can i bypass this?