Re: using CAST and LIKE

On Mon, 2002-04-15 at 15:46, Tom Lane wrote:
> 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
>

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,