works fine for more.
select whatever from whatever where whatever='blah&blah';
and
select whatever from whatever where whatever like '%&%';
both return the expected results in psql.
-tcl.
On Fri, 19 Mar 1999, Jonathan A. Zdziarski wrote:
> Oddly when I attempt to do a
>
> SELECT * FROM database WHERE "field" = 'anything with an & sign in it'
>
> it returns nothing.. How do you refer to &'s so that it will return the
> fields?
>
> Thank you,
>
> Jonathan A. Zdziarski
> Sr. Systems Administrator
> Netrail, inc.
> 888.NET.RAIL x240
>
>
>