Re: dash in a varchar column - effect on select statement

[Rick Hillegas]

On 12/6/11 7:45 AM, Danny Gallagher wrote:

SELECT * FROM TABLE WHERE NAME = 'LKFSASP'

Hi Danny,

I can't reproduce this problem (see the script below, which runs 
correctly for me). Are you using a special collation in this database?

connect 'jdbc:derby:memory:db;create=true';

create table t( a varchar( 50 ) );
insert into t( a ) values ( 'LKFS-ASP' );

-- no results
select * from t where a = 'LKFSASP';

insert into t( a ) values ( 'LKFSASP' );

-- returns 1 row
select * from t where a = 'LKFSASP';

Thanks,
-Rick