Varchar search is very literal

Hi,

I have found that with a varchar2 field that searches seem to care about trailing spaces, i.e.:

create table fred (fld1 varchar(10))
insert into fred values ('cat ') -- 4 spaces after 'cat' commit

select * from fred where fld1 = 'cat'

returns zero rows. With regular 'Char' this works just fine.

Is there a way to alter this behavior, or is this just the way it is?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 30 2000 - 15:23:54 CDT