> A direct query gets appropriate rows of data:
>
> dbname=# select * from partdef where shpname = 'IDC16W';
> ...while the very same query (substituting LIKE for the '=' sign) gets
nothing!?
>
> dbname=# select * from partdef where shpname LIKE 'IDC16W';
> Can someone please tell me the really stupid thing that I'm doing wrong?
Just a guess here... is shpname a CHAR field (which would be padded with
spaces)? If so you'd have to do LIKE 'IDC16W%'
Greg
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
