[This topic is migrated from our old forums. The original author name has been removed]
This may be a DB2 problem only: when using a string containing a single quote in the input field for the Where Filter on the Table/Data view it should be doubled to avoid an SQL syntax error. (DBVis 5.1.1)
e.g. an input of Sam's Bar
should become LOCATION = 'Sam''s Bar'
about 12 years ago
[This reply is migrated from our old forums.]
Re: Using single quotes in the Where Filter
I'll add this to the feature request list.