Help for this page
UPDATE category SET chrCat_Full_Name=UPPER(LEFT(chrCat_Full_Name,1)) +LOWER(RIGHT(chrCat_Full_Name,DATALENGTH(chrCat_Full_Name)+1))
use DBI; require DBD::ODBC; ## will be done auto, but doesn't hurt to check. ... $db->disconnect; $db2->disconnect;