Perfect! Thanks Sean. Steve
-----Original Message----- From: Alford, Sean [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 8:46 AM To: CF-Talk Subject: RE: SQL UBound? Steve, I think you are looking for the aggregate function max(). SELECT MAX(COL) FROM TBL Sean -----Original Message----- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 8:37 AM To: CF-Talk Subject: SQL UBound? I'm looking for the SQL function that will return the highest value in a column. I have a field that is the datatype 'decimal' and I want to return the record with the highest value in that column. Can someone help me? Thanks, Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.