Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
LIKE operator returns no results without percent wildcard. |
Sat, Mar 10 2007 1:08 AM | Permanent Link |
Dave M | 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 |
Sat, Mar 10 2007 1:47 AM | Permanent Link |
Dave M | Disregard my previous message, It should have been posted in ElevateDB, not DBISAM.
Dave M |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |