Depending on what column and type, you could do: select min(columnName), max(columnName) FROM table
V/r, Charles -------------------------------------------------- Charles Pelkey C.P Web Designs <[EMAIL PROTECTED]> http://www.cp-webdesigns.com/ ICQ: 8294384 MSN: cpwebdesigns Y!im: cp_designz Fax & voicemail: (928) 962-2939 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
