'hello world' > 'Hello world' update tableName set columnName=CHAR(ASCII(SUBSTRING(columnName, 1, 1))-32)+SUBSTRING(columnName, 2, len(columnName)) WH ...
'hello world' ----> 'Hello world'
update tableName set columnName=CHAR(ASCII(SUBSTRING(columnName, 1, 1))-32)+SUBSTRING(columnName, 2, len(columnName))
WHERE (ASCII(SUBSTRING(columnName, 1, 1)) >96) AND (ASCII(SUBSTRING(columnName, 1, 1)) < 123)
update tableName set columnName= STUFF( columnName,1,1,UPPER(SUBSTRING(columnName,1,1)))
