Hi,

Can someone tell me why this query doesn't work ?

SELECT *
FROM CATuntec
WHERE Code_Cat LIKE '__'

When I use this query with DBISAM table, it's working

Thanks for your help

Bruno

Looks like a bug to me.


select * from callstats where _result like 'WR_NG'

returns the expected rows

select * from callstats where _result like 'WR_N_'

returns nothing


Roy Lambert

Bruno,

<< Can someone tell me why this query doesn't work ?

SELECT *
FROM CATuntec
WHERE Code_Cat LIKE '__'

When I use this query with DBISAM table, it's working >>

It's a bug when the single wildcard is used as a trailing character in the
LIKE pattern value - I'll have a fix in build 14 for it.

--
Tim Young
Elevate Software
www.elevatesoft.com