Re: LIKE erratic? or unseen DB corruption?

On Mon, 21 May 2001, Len Morgan wrote:

> Is it possible that there are spaces after the 'IDC16W' in the field?  Try:
>
> LIKE 'IDC16W%'
>
> and see if that makes a difference.
>
> len

Indeed it does allow 'LIKE' to find the item -- this item has
the type char(16).  Thanks!

    -frank

> >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)
> >