# 647 Embedded Quotes in SQL and Filter Strings Not Being Handled Properly

---

I use some code witxh produces Selects from user entries. Now I get a problem if the user enters a " or ' in his text. The resulting SQL will than look as this;

Select * From TableXY Where Field1 like '%Title 'das"jsjs'%';

The user entered: Title 'das"jsjs'

Is there a way for DBISAM to transform the user text into a form which is valid in the SQL? At the moment we get an error, as you for sure knowns. In most cases Parmeters can solve this problem, but in my situation the SQL is generated from a 3rd party bibliothek.