[Zope] Passing multi-line field into SQL

We have a form with a textarea on it, that can contain line breaks. When we try to pass it into an SQL statement <dtml-sqlvar textarea_value type=string> we get a parsing error, due to the embedded newlines. We would like to convert the newlines to "<BR>" strings. Does anyone have an easy solution for doing this? We have tried using split/dtml-in and split/join in the SQL, but getting these statements past the SQL parser, with all the quotes, has proven to be tricky. ..tony..