• drew.allen - Tuesday, February 6, 2018 1:02 PM

    And what happens when someone has a first name that includes a space?  "Jackson, La Toya"

    Drew

    A valid point.  It seems then I'd need something that would look for the comma on the left and only a space in the 2nd character position from the right, possibly?

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.