FOR JUST UPPER CASE

SELECT UPPER(column)

FROM table

http://www.brettb.com/SQL_Help_Change_Lower_Upper_Case.asp

FOR 1st LETTER UPPER CASE

SELECT

UPPER(LEFT,1))+

(RIGHT((column,len((column)-1))

FROM table