Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Bug using TRIM and LIKE with COLLATE UNI? |
Mon, Sep 30 2013 3:37 AM | Permanent Link |
Hedley Muscroft | Hi,
Here's my SQL :- select id, lastname, firstname, title from per where trim(both ' ' from firstname) COLLATE UNI_CI like 'Vincent' This returns :- ElevateDB Error #700 An error was found in the statement at line 2 and column 37 (Expected end of expression but instead found COLLATE) If I remove the TRIM or the COLLATE then it works fine, however I really need both. Is this a bug or am I doing something wrong? Thanks, Hedley Muscroft Pioneer Software |
Mon, Sep 30 2013 3:59 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Hedley
Try select id, lastname, firstname, title from per where trim(both ' ' from firstname COLLATE UNI_CI) like 'Vincent' Roy Lambert [Team Elevate] |
Mon, Sep 30 2013 5:35 AM | Permanent Link |
Hedley Muscroft | Excellent - that works thanks.
|
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 |