Showing posts with label lower case. Show all posts
Showing posts with label lower case. Show all posts

Sunday, 27 September 2009

Display information in Upper and Lower case from SQL database

In my database table (products) I have a column called items that lists a number of products in sentence case. In order to display them in upper and lower case I do the following :

Open query analyser.
Select the required database.

Upper case

Select upper (item) from products

Lower case

Select lower (item) from products