The fields of DEPT table are ID int, Description char or varchar


what is the use/significance/advantage of using max function on a char/varchar field in the following query ?

select max(Description) from DEPT

use:== finds highest collating description

significance:== depends on the business application whether this means anything

advantage:== easiest way to do it, built right in to SQL