Formatting Database results



I have a database that has values in it like City and State…


City State

Chandler Arizona

Mesa Arizona

I want to pull out that information from the database but i need it to be lowercase.

The reason im doing this is becase when a user signs up, it creates a directory and copys files into it. I need to make the folder name all lowercase.

Is this possible to do…

In database City = Chandler

I need result as City = chandler