I know for sure that LEFT, RIGHT don't work. I would suspect that most string parsing functions will not work.
And, while I haven't tested them, when I posted about this on the forums, I got responses that the following also do not work: -- CASE, DECODE, joins between more than 2 tables, LEFT and RIGHT joins. -- Count() returns Null rather than 0 when there aren't any records returned. Cheers, Kris > It would be very nice to have a complete feature list of > SQL commands and such that works with QoQ. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4