Formatting Text
You must include a format character for each text character. The following example shows how you can use the FORMAT function to display text in uppercase:
SELECT (FORMAT(empfname,'________')) FROM employee
Using FORMAT
Without FORMAT
JUNE
June
ERNEST
Ernest
PETER
Peter
