Since character fields are generally delimeted by single quotes, if i want to insert a character string like player name that may contain a single-quote or use a WHERE clause and do a comparison against a sting that might contain a single-quote how would I escape the single quote in that string variable?
In perl this is easy,
Code:
$name =~ s/'/\\'/g;
but I am not so sure how to do this in small.
Thanks

Mug