Yeah, simplest way always wins! Lol I just wondered if anyone else had ever come across this before?
Cheers Tristan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Posted At: 20 June 2007 14:26 Posted To: Profox Archive Conversation: Select statement with a max() of 2 values Subject: Re: Select statement with a max() of 2 values Why not create a little UDF, and use that in the SQL? FUNCTION FoxMax(p1, p2) RETURN MAX(p1, p2) SELECT f1, f2, FoxMax(f5,f6) as test FROM t1...... -- Ed Leafe -- http://leafe.com -- http://dabodev.com [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.