Hi Try this in the message box
put "abc" into ttxt put toUpper(char 1 of ttxt) into char 1 of ttxt put ttxt will return Abc Regards Ian McKnight On 28/02/2008, dcpbarrington <[EMAIL PROTECTED]> wrote: > > 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 > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > -- Regards Ian ======================= Ian McKnight [EMAIL PROTECTED] ======================= _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
