Hi all,
Sorry if this has already been posted but the archives, as you probably
already know, aren't searchable right now and I did not see anything
relevant when I sifted through them. Anywho, I'm trying to use a type
cast in a where ... like select statement and I've done it like so:
SELECT * FROM table WHERE CAST('field' AS TEXT) LIKE '%value%';
now the field I'm casting, be it already of type text or not, never
returns any rows. However if I use a field that is already of text type
and do not cast it then I get resluts. So my question is is there any
way to use CAST and LIKE together in the same select or am I
missing/doing something wrong? Thanks.
Timothy,