On Fri, May 25, 2018 at 11:04 AM, tango ward <tangoward15@xxxxxxxxx> wrote: > CASE > WHEN code like '%%PE%%' or code like '%%NSTP%%' > THEN True > ELSE False I cannot advise you on the %% stuff, which I do not totally understand, but CASE WHEN condition THEN true ELSE false END when contition is ( as it should in a CASE ) a boolean expression is a classic antipattern , just use 'condition' or '(condition)' Francisco Olarte.
