Database Looping issue with '\' character

KNIME Analytics Platform
1

Hi,

The database looping node is returning data when it should not.  My column contains the value %DL\%, the query using a Like is passed as argument to the db looping node.  All "DL-xxxx" records are returned when they should not.  I'm searching for the vendorbatchid containing the DL\ string.  See screen shot attached. 

The sql statement does not return any data. 

Thanks in advance for your help on this,

Regards,

Claire

2

This is a complete guess, because I don't use that node, but is the backslash being treated as an escape character so that the actual query ends up being DL% which is why it matches all records beginning with DL? In that case you could try adding a second backslash to escape the first one i.e. %DL\\% .