On 2/28/08 3:08 PM, "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. put toUpper(char 1 of userStr) && toLower(char 2 to -1 of userStr) into goodStr Jim Ault Las Vegas _______________________________________________ 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
