Capital Letters

Results 1 to 2 of 2

Thread: Capital Letters

  1. #1
    Join Date
    Dec 1969

    Default Capital Letters

    I have a SQL server database of names and address that need to be run through a mail merge. It is important for us to take the current UPPERCASE and change it to lowercase leaving the first letter of each word Uppercase. Also needed, is to remove any unnecessary spaces from the each field as well. Example below:<BR><BR>I need this address:<BR>"888 E LAS OLAS BLVD. SUITE 1234"<BR>To read...<BR>"888 E Las Olas Blvd. Suite 1234"<BR><BR>Does anyone have a function written already that would make my life easier (it is saturday, dont like to work weekends)<BR>Thanks you in advance

  2. #2
    Join Date
    Dec 1969

    Default proper case

    I think it is the name for it...<BR>Search here or google for it...<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts