Table Filter truncates and changes values using IN clause

From the screen shot attached, you can see that the filter values entered had the last character lost and the dashes "-" had spaces added before and after them. This is undesired behavior. Values entered: DOH-4272, DOH-3999, DOH-4029, DOH-242, DOH-242C What filter produced: PRODUCTID IN ( 'DOH - 4272', 'DOH - 3999', 'DOH - 4029', 'DOH - 242', 'DOH - 242' ) Version is 6.5.4 Edited by: Timothy Troy on Mar 9, 2009 6:16 PM

Hi Timothy, Thanks for reporting this. The problem occurs when using an IN/NOT IN condition for a character column where the comma separated values contain special characters like "-". A work-around is to manually quote the values, i.e. enter the list like this instead: 'DOH-4272', 'DOH-3999', 'DOH-4029', 'DOH-242', 'DOH-242C' We will look into a way to handle the quoting automatically even for this case. Kind Regards, Hans