in reply to Clean a database record off an apostrophe '

You can remove the character altogether: $field =~ tr/'//d, or you could backslash it: $field =~ s/'/\\'/g, or perhaps replace it with the HTML entity code ''': s/'/'/g;

_____________________________________________________
Jeff[japhy]Pinyan: Perl, regex, and perl hacker, who'd like a job (NYC-area)
s++=END;++y(;-P)}y js++=;shajsj<++y(p-q)}?print:??;