Re: LIKE erratic? or unseen DB corruption?

Is it possible that there are spaces after the 'IDC16W' in the field?  Try:

LIKE 'IDC16W%'

and see if that makes a difference.

len

>A direct query gets appropriate rows of data:
>
>dbname=# select * from partdef where shpname = 'IDC16W';
> pn_id | class | num  | mt | ver | loc_id | unit_id | subptcnt |
shpname      |   value    | descrip
>-------+-------+------+----+-----+--------+---------+----------+-----------
-------+------------+---------
>    17 | 328   | 08X2 | 0  | 0   |        |         |        1 | IDC16W
| Header-8x2 |
>    11 | 323   | 08X2 | 0  | 0   |        |         |        1 | IDC16W
| Header-8x2 |
>
>...while the very same query (substituting LIKE for the '=' sign) gets
nothing!?
>
>dbname=# select * from partdef where shpname LIKE 'IDC16W';
> pn_id | class | num | mt | ver | loc_id | unit_id | subptcnt | shpname |
value | descrip
>-------+-------+-----+----+-----+--------+---------+----------+---------+--
-----+---------
>(0 rows)
>