Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
LIKE operator returns no results without percent wildcard. |
Sat, Mar 10 2007 1:50 AM | Permanent Link |
Dave M | Sorry for accidentally posting twice (once in DBISAM general).
SQL operator LIKE can not return exact match or single character wildcard without %. Sql below returns no results for Jones: -------------------------------------------- SELECT * from sometable WHERE lastname = 'Jones' SELECT * from sometable WHERE lastname = 'J_nes' This SQL returns Jones (plus records such as Jones/Smith): ------------------------------------------------------------------- SELECT * from sometable WHERE lastname = 'Jones%' SELECT * from sometable WHERE lastname = 'J_nes%' Dave M |
Mon, Mar 12 2007 4:45 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dave,
<< SQL operator LIKE can not return exact match or single character wildcard without %. >> Got it. The workaround is to use the equals operator instead for now. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |