Re: using CAST and LIKE

Timothy Wood <timothy@hallcomp.com> writes:
> SELECT * FROM table WHERE CAST('field' AS TEXT) LIKE '%value%';

I think you meant

SELECT * FROM table WHERE CAST(field AS TEXT) LIKE '%value%';

            regards, tom lane