Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
LIKE not working correctly? |
Tue, May 24 2016 6:00 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Before I report it as a bug can someone confirm this for me. I'm checking to see if an email's sender matches a mask.
eg one entry in emBlackOrWhite is %yousave__.co.uk LIKE only operates if the column is second select * from emBlackOrWhite where :EMail like _EMail returns one row but select * from emBlackOrWhite where _EMail like :Email doesn't return any. I could be misinterpreting the manual LIKE Returns True if the left string expression matches the right pattern expression. ... If so I'll have to work up a UDF to handle it. Roy Lambert |
Tue, May 24 2016 12:14 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
Is the _Email column the pattern ? If so, then everything is fine. Tim Young Elevate Software www.elevatesoft.com |
Tue, May 24 2016 1:29 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Yup - it was me misreading/misinterpreting the manual - pattern on the right not the left. Roy Lambert |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |