marsh,

> I have this sql statement:
>
> SELECT * from tBooks where BookNbr = '20111122-001'
>
>
> BookNbr is defined as varchar (15), and the record does exist in the
> table. The user has populated this field with dashes in the field,
> sometimes multiple dashes, sometimes none.
>
> I removed the dash and changed the field in the table, and it found
> the record. Therefore, I think the problem is the dash in the "key"
> field.

there are multiple similar-looking dashes in the character table. Are
you sure you are using the same as your user?
--
Nando Dessena