BAQ dies on single quote in customerID

I have a combobox with a dynamic list that pulls from a BAQ. The BAQ criteria filters against the customer ID. If the customer ID has a single quote in it, there is a bunch of errors since the BAQ criteria thinks it has reached the end of the string and the rest is code. We only have 10 or so customer ID’s with single quote marks / apostrophe in their ID, so I am just having them remove it. But I was wondering if there was another way of handling this. Thoughts?

Its probably a sanitation issue with the “where” clause that is applied. Not much you can do, that shouldn’t happen report it as a bug.