janerussel
MIS
In a select statement, can I force the results to ALL CAPS. I will be exporting the data and need it in this format.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
force text to all CAPS
- Thread starter janerussel
- Start date
- Status
There is a function, Ucase, which returns the string expression in all caps.
So if your Select statement was
SELECT first, last from Employees;
you could use
SELECT Ucase(first) as UFirst, Ucase(last) as ULast from Employees;
Hope that helps.
Kathryn
So if your Select statement was
SELECT first, last from Employees;
you could use
SELECT Ucase(first) as UFirst, Ucase(last) as ULast from Employees;
Hope that helps.
Kathryn
- Status
Similar threads
- Locked
- Question
- Locked
- Question