Wouldn't that be something like UPPER(LEFT(Target_String,1)) + SUBSTR(Target_String,2)
Leave the optional LENGTH value off of the SUBSTR function to get the rest of the text. Gp George Payne Assistant Director, User Services Information Technology Services University of Texas at Austin 512.232.7513 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Thornley Sent: Wednesday, May 23, 2007 9:58 AM To: arslist@ARSLIST.ORG Subject: Set Field Function All I can't seem to figure out the formula to set the first character only in a field to uppercase. Thanks Kevin __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"