Convert to Title Case 1

[Gnism]

In our database the first_name field is in ALL CAPS. How can I convert/display the name JOHN to John in the query results or the report?

 

[carp]

This probably depends on your RDBMS. In Oracle, you could use the INITCAP function:

SELECT initcap(first_name)
FROM my_table
WHERE first_name = 'JOHN';

INITCAP(FIRST_NAME)
--------------------
John

 

[Gnism]

That's what i needed - Thanks.