![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Thu, Jan 3 2008 11:38 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
In ElevateDB I just tried to set a filter _BoxName LIKE 'selling%' COLLATE ANSI_CI and it barfed on collate. Does this mean that filters and sql are diverging? Roy Lambert |
Fri, Jan 4 2008 7:53 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< In ElevateDB I just tried to set a filter _BoxName LIKE 'selling%' COLLATE ANSI_CI and it barfed on collate. Does this mean that filters and sql are diverging? >> Wrong syntax, the collation always goes after the column name: _BoxName COLLATE ANSI_CI LIKE 'selling%' -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jan 4 2008 8:53 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
>Wrong syntax, the collation always goes after the column name: See I told you I was still in learning mode. This identifies one of the things I dislike about SQL. Some things have to be in a certain order and others don't and I generally fail to remember which is which ![]() Roy Lambert |
This web page was last updated on Wednesday, July 2, 2025 at 06:46 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |