Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Location
    Chennai
    Posts
    16

    Question Unanswered: Extracting initials from Name ?sql query

    Hi friends,

    I need to extract the initials from Emp_name which is of type char(30)

    The name field may contains the values as

    First-name, middle name, last-name
    or
    First-name, last-name
    or
    First-name

    e.g
    Name: Maria Mendoza
    initial: MM

    Name : Ramesh
    initial : R

    is that possible to write as a single query with locate & substr functions.

    Thanks,
    Ramesh
    Learning, Keep on learning.....

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You can do it as a UDF.

    Andy

Posting Permissions

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