in reply to Re^2: SQL LIKE and Binding Variables
in thread SQL LIKE and Binding Variables

For postgres, the string concatenator would have to be '||' instead of '+'.

(A quick test seems to indicate SQLite wants '||' as well, which makes sense as that is the standard SQL concatenator)

see (maybe) also: dbi, placeholder and postgres regular expression problem

hth