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