On Fri, Feb 3, 2017 at 10:12 AM, Chuck Roberts <croberts(at)gilsongraphics(dot)com>
wrote:
>
> AND (TRIM(tbl.costcenter) IN ('540'))
>
> Can anyone shed some light on this for me?
>
>
It works...
WITH tbl (id, costcenter) AS ( VALUES (1, '500'), (2, '550') )
SELECT *
FROM tbl
WHERE (trim(tbl.costcenter) IN ('550'));
So the problem resides in something you haven't show us - namely data.
David J.