This has to be very simple, but I cannot find anything in the DOCs or an example.
I have a database that I want to allow the user to querry a record by the persons last name. So I have a simple entry box with a button to querry the database. Works great as long as the user enters the text string in the same case as has been entered in the database. "Smith" = "Smith", but if the user enters "smith" in the select box, the record is not found. I want to do the database select with different text formats to make sure that the record is found. SELECT on "Smith", "smith", "SMITH" I found the toupper() and tolower() functions, but how do you get the function to change only the first letter toupper in a string? Thanks in advance for the help. This cannot be that hard. -- View this message in context: http://www.nabble.com/Change-Case-of-first-character-of-text-string-tp15748287p15748287.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
