easy one for you programming guru's

  • How do i accomplish the following.

    Take a name that has been entered (i.e. bill smith) and make it into Bill Smith.

    I know how to accomplish getting the bill to Bill, but I'm not sure on the code to use in finding the beginning letter of the lastname and making it Upper.

    Any help would be great. Thanks.

  • In VB you can take a shortcut and use the strconv function, has an option that will proper case everything. If you're doing it manually the basic sequence is to find a space and then capitalize the next letter, then look for another space until you reach the end. Plus always doing the first letter. Some names defy this convention, but it's close enough usually.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • I seem to remember seeing a string propering script at http://www.swynk.com

    -Mike

    Michael Levy

    ma_levy@hotmail.com


    Michael Levy
    ma_levy@hotmail.com

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply