Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Filters & sql |
Thu, Jan 3 2008 11:38 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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. timyoung@elevatesoft.com | 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 Team Elevate | 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 Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |