Joshua Hudson Joshua Hudson - 1 year ago 76
SQL Question

SQL changing a value to upper or lower case

How do you make a field in a sql select statement all upper or lower case?

Example:

select firstname from Person

How do I make firstname always return upper case and likewise always return lower case?

Answer Source
SELECT UPPER(firstname) FROM Person

SELECT LOWER(firstname) FROM Person
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download