Forum Replies Created

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

  • RE: Parsing a string...between a comma and space

    Hi,

    I need to parse last name,first name space middle name.

    Example A - DOE,JOHN

    Example B - DOE,JOHN A

    I am able to parse the last name.

    left(dbo.AbstractData.Name, charindex(',', dbo.AbstractData.Name)-1) as last name

    I can...

  • RE: Parse Full Name Into Last, First and Middle

    Hi,

    I need to parse last name,first name space middle name.

    Example A - DOE,JOHN

    Example B - DOE,JOHN A

    I am able to parse the last name.

    left(dbo.AbstractData.Name, charindex(',', dbo.AbstractData.Name)-1) as last name

    I can...

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