Hi,
I need to escape characters for a MySQL insert, but it has to be done in SQL instead of
Java since its part of a trigger. In particular:
& --> &< --> <> --> >' --> '\ --> "e; Right now, the following works:
But this is awfully messy... any chance there's something more elegant that can be done in one line?
[ February 12, 2008: Message edited by: Scott Selikoff ]