![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Fri, Jun 4 2010 4:19 AM | Permanent Link |
Josselin | 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 |
Fri, Jun 4 2010 4:56 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Sat, Jun 5 2010 1:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |