Change Case of first character of text string

[Eric Chatonet]

Hello,

Due to time difference, I am a bit late in this thread but I would  
like to consider this problem from another point of view :-)
Instead of having to search for all forms ('smith', 'Smith' or  
'SMITH') I would rather prefer to reformat user entries as soon as  
they are done to match a 'style' sheet that will make all data  
display consistent.
To achieve such a goal, you might be interested in my "How to master  
user's data entries" tutorial:
This stack shows you how to allow the user to type the data you  
expect according to a format in an entry box field.
Five examples are provided from a simple ZIP code to custom  
sophisticated formats.

You will access this tutorial through "Tutorials Picker" a free  
plugin that interfaces with the So Smart Software website in order to  
display all available tutorials stacks directly from the web.
You will find it by going to http://www.sosmartsoftware.com/.
Revolution/Plugins or Tutorials section.

Best regards from Paris,
Eric Chatonet.

Le 29 févr. 08 à 00:08, dcpbarrington a écrit :

> 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.

----------------------------------------------------------------
Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/
Email: eric.chatonet at sosmartsoftware.com/
----------------------------------------------------------------