Hi, in general it's a bad idea to build SQL by hand like that. As you have found, you quickly run into complications with quoting, special characters, etc.

At a minimum you should build the SQL statement with "placeholders" and "bind values" (look for those terms in the DBI docs). But your life may be made easier if you use SQL::Abstract or SQL::Abstract::More.

Hope this helps!