Gareth Horton
July 12th, 2002, 02:27 PM
If you use the 'MEDIA' field from the Monarch tutorial report (the one that contains invoices for music - am not allowed to write the name of it since this stupid board considers the name offensive) as an example, following calculated field statement will make the conversion for you:
Substr(media,1,1)+Lower(Substr(media,2,4))
Joel Heyman wrote:
> Does anyone know a better way of making words in uppercase into Proper case (first letter Upper case)? There doesnt seem to be a function for it.
Substr(media,1,1)+Lower(Substr(media,2,4))
Joel Heyman wrote:
> Does anyone know a better way of making words in uppercase into Proper case (first letter Upper case)? There doesnt seem to be a function for it.