I would recommend Jim's suggestion, with a slight modification. Since he wanted ucDescription contains "Graduate Certificate", I think in SQL Server that would be "LIKE"
Anyway try this. <cfquery datasource="computedColumnTest" name="testquery"> SELECT ucDescription, ucTitle, CASE WHEN ucDescription LIKE '%Graduate Certificate%' THEN 1 ELSE 2 END AS seq FROM testtable ORDER BY seq </cfquery> Good luck, Ali >Jim Wagner wrote: >Use a CASE statement in your SQL... ><cfquery datasource="computedColumnTest" name="testquery"> >SELECT ucDescription, ucTitle, >CASE WHEN ucDescription = 'Graduate Certificate' THEN 1 ELSE 2 END AS seq >FROM testtable >ORDER BY seq ></cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
