Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: Parsing a name field

    Hi,
    I have a name field that has many variations and been fighting with it for a few days. The possible name variations are:

    Smith, Mike
    Smith, Mike K.
    Smith, Mike K., JR.

    I would like to parse each of the for pieces in a separate field.

    Help is much appreciated.
    Thanks
    Mo

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Function attached.
    Attached Files Attached Files
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106
    hi,
    this is a code to use in a procedure. Is there a way to do it in a query?
    Thanks
    Mo

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No, its code for creating a user-defined function, which you can then call from query.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Tags for this Thread

Posting Permissions

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