Home Forums SQL Server 7,2000 T-SQL converting name.. RE: converting name..

  • June 28, 2003 at 8:31 pm

    #463579

    I"ve used the following, but DAVNovak's idea is pretty cool

    SELECT LEFT(Firstname, 1)

    + " " LEFT(Middle, 1)

    + " " Lastname