dcsimg
Results 1 to 4 of 4

Thread: TSQL help

  1. #1
    Laura Guest

    TSQL help

    Hi,

    I am trying to break up a column "name" into 2 columns "first name" and "last name". The name colum is currently "lastname, firstname". Is there an easy way to do this in SQL 6.5?

    I successfully extracted the first name using:

    firstname = rtrim(substring(name, (charindex(',', name)), 25))

    But I am having trouble doing the lastname. Please help.

    Thanks so much!
    Laura

  2. #2
    jkv Guest

    TSQL help (reply)

    Hi Laura,
    try this:
    firstname = substring(name, 1+(charindex(',', name)), 25),
    lastname = substring(name,1,(charindex(',',name)-1))


    ------------
    Laura at 6/5/00 5:20:50 PM

    Hi,

    I am trying to break up a column "name" into 2 columns "first name" and "last name". The name colum is currently "lastname, firstname". Is there an easy way to do this in SQL 6.5?

    I successfully extracted the first name using:

    firstname = rtrim(substring(name, (charindex(',', name)), 25))

    But I am having trouble doing the lastname. Please help.

    Thanks so much!
    Laura

  3. #3
    Laura Guest

    TSQL help (reply)

    Hi JKV,

    Thanks for your help! However, I got this message when running the script:

    Msg 536, Level 16, State 1
    Invalid length parameter passed to the substring function.

    It's caused by the lastname field. Any Ideas?


    ------------
    jkv at 6/6/00 4:20:43 AM

    Hi Laura,
    try this:
    firstname = substring(name, 1+(charindex(',', name)), 25),
    lastname = substring(name,1,(charindex(',',name)-1))


    ------------
    Laura at 6/5/00 5:20:50 PM

    Hi,

    I am trying to break up a column "name" into 2 columns "first name" and "last name". The name colum is currently "lastname, firstname". Is there an easy way to do this in SQL 6.5?

    I successfully extracted the first name using:

    firstname = rtrim(substring(name, (charindex(',', name)), 25))

    But I am having trouble doing the lastname. Please help.

    Thanks so much!
    Laura

  4. #4
    Guest

    TSQL help (reply)

    Thanks Deepak!!! That worked!


    ------------
    Deepak at 6/6/00 5:08:52 PM

    hi,

    lastname = select substring( colname , 1, charindex(',', colname,1) -1 ) firstname = select ltrim(substring(colname,charindex(',', colname,1) + 1, len(colname)- len(substring( colname, 1, charindex(',', colname,1) -1 ))))

    Deepak.


    ------------
    Laura at 6/6/00 9:56:10 AM

    Hi JKV,

    Thanks for your help! However, I got this message when running the script:

    Msg 536, Level 16, State 1
    Invalid length parameter passed to the substring function.

    It's caused by the lastname field. Any Ideas?


    ------------
    jkv at 6/6/00 4:20:43 AM

    Hi Laura,
    try this:
    firstname = substring(name, 1+(charindex(',', name)), 25),
    lastname = substring(name,1,(charindex(',',name)-1))


    ------------
    Laura at 6/5/00 5:20:50 PM

    Hi,

    I am trying to break up a column "name" into 2 columns "first name" and "last name". The name colum is currently "lastname, firstname". Is there an easy way to do this in SQL 6.5?

    I successfully extracted the first name using:

    firstname = rtrim(substring(name, (charindex(',', name)), 25))

    But I am having trouble doing the lastname. Please help.

    Thanks so much!
    Laura

Posting Permissions

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