Proper Case

[redoakhg]

Is there a ColdFusion tag that functions like Proper in Excel? I have all of this data entered by sales people in ACT that I pulled into MS SQL 2000, but it seems some of the sales team have caps lock stuck on because the first and last names are all in upper case. I would like to present it back to the customer in proper case. I was hoping there was something like #Proper(firstname)# so I don't have to pull it into Excel to clean up.

Thanks!

 

[GUJUm0deL]

You have several options.

1. LCase() function -

http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt2.htm#3715250.

2. CapFirst() function -

http://www.cflib.org/udf.cfm?ID=9

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[redoakhg]

Thanks!