Re: query strangness

look for hidden characters or whitespace...

try the LIKE syntax instead of =
e.g.

lastname LIKE '%test1%'

hth
Randy

Sebastian Degenaar wrote:
>
> I am having difficulty in oracle 8i for Win NT just doing a simple query
> on a varchar2 field. It works fine to query on any integer field,
> however if I try for example;
>
> select * from USER.CUSTOMER where LASTNAME = 'test1' i get no rowset.
> Why is this. It seems to work on some varchar fields and not others.
>
> Any help greatly appreciated!
Received on Tue Oct 26 1999 - 10:25:58 CDT