Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

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