Database Lookup SQL Issue

I am trying to preform a database lookup on a value that has an ' in it.  So the value is Lloyd's because of the ' , the lookup is throwing me an error.  I assume this is because the SQL statement is not parsing the ' correctly?  I am using Grooper version 2.8; is there a way to fix this parsing with the apostrophe with custom SQL for database lookup using the field as a variable?

Best Answer

Sign In or Register to comment.