Personally, I would put the values into proper case before putting them into the database. That means you only have to process the text once... Not once for each time you read it from the database.
....................... Ben Nadel www.bennadel.com -----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:249060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4