More like a.code + '%'. Just the right side, not both. Your original example was flawed in any event, as you'd have been looking for the literal word a.cidcode, not what was in the variable ...