I want to be able to use the contents of an array in a like clause, but can't figure out how. Is there a cast function or similar that can give me a textual representation of an array field?
Your question is not clear. Please provide an example together with the definition of the column that is an array..
My bad. I see now that I can treat the field essentially as a varchar field and use like against it, or use something like POSITION_ARRAY to look for elements
Look up the UNNEST keyword for accessing the elements as a table.