I'm working on a project with ColdFusion, an Oracle db and some PL/SQL triggers. In one of my cfm pages I made it possible to order the data in a table on their subject and date. The problem is that an order by subjects put everything in the order shown in the example
-This is a test
-What are you doing
-all things have been said
You see? First the data with the capital letters and than the subjects with a small letter ... but a must stand before the T!!! So I want the data you insert in the database to be placed in a specified form. First letter capital, rest of the text lowercase letters. But I want to give the possibility to the users to insert the data in any possible way. If they insert 'HALLO' that must be changed into 'Hallo'.
So I tried to put in my insert command some functions (substr, upper and lower), but it just doesn't work ... possibly a wrong nesting. Who can help me???