Try using CapFirst() from cflib.org, works great, though you will still have to write a regex for things like "McMillan".
Thanks, Mark -----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, August 07, 2006 5:14 PM To: CF-Talk Subject: Proper Case Just wondering if there is an Easier way of doing these things. By default I submit all text fields to the DB: dbvalue = '#lcase(form.field)#' then with CSS Style my outputs as <span style="text-transform:capitalize">#dbvalue#</span> for fields Like Name or Address... Is this the best way to be handling this? Or is their some way to pass the form field Value pre converted to Proper before it is inserted? I've burned by data entry ppl that suck before. -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 "IF-THEN-ELSE its a way of life!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
