On Mon, 2002-04-15 at 15:46, Tom Lane wrote:
> Timothy Wood <timothy(at)hallcomp(dot)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
>
Ahh, that does seem to work. Big difference without the single quotes.
What exactly is the big difference there or what do the single quotes do
that I was not aware of when I used them?
The regular expressions do seem like a better idea, but is there any
benefit over one or the other aside from the flexibility of the regexps?
Thanks again
Timothy,