One way is using string functions. Left() to grab the first
letter and UCase() to capitalize it. You can use Right() and Len()
to grab the rest of the word.
You can see an example of something similar at cflib.org. But
read the usage on how it operates if you pass multiple words.
http://www.cflib.org/udf.cfm?ID=9
Both methods work. While I would probably choose regex
myself, I know not everyone feels comfortable with them. They're
certainly not as intuitive as string functions. Use whichever you
feel most comfortable with. Though regex are very powerful and well
worth learning.
cf_dev2 wrote:
> One way is using string functions. Left() to grab the
first letter and
> UCase() to capitalize it. You can use Right() and Len()
to grab the rest of
> the word.
>
> You can see an example of something similar at
cflib.org. But read the usage
> on how it operates if you pass multiple words.
>
http://www.cflib.org/udf.cfm?ID=9 >