I have a table with a number of columns called code1 code2 code3 code4 etc. Each of these columns has a numeric value. What I want to do is find the highest value in a column for each row and place that value in a newly generated column, ie if code1 has the highest value of all the codes then place that value in the new column (or even in an existing column). I have tried many sql select statements without success. Is this possible?
Richard _________________________________________________________________ Richard Waters <[EMAIL PROTECTED]> Manager Information Technology Wentworth Shire Council <[EMAIL PROTECTED]> Tel (03) 5027 5027 Fax (03) 5027 5000 "The opinions expressed above are not necessarily the opinions of the Wentworth Shire Council" **IMPORTANT NOTICE** The information contained within this email message should be considered as confidential and/or privileged and is intended solely for the addressee named above. If you have received this message in error you must not use, copy, forward, print or otherwise disseminate any information contained within this email. Please ensure that a confirming message is returned to the sender advising the error has occurred and the email has been deleted. Thank you in anticipation of your co-operation. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5311
