Post reply

Remove a $ sign in username field of the table

  • December 12, 2007 at 11:45 am

    #62323

    I would like to run a script to remove a $ sign in the username field in the employee table. Please Help!

    EMPLOYEE table:

    Lastname Firstname Username

    Doe John doej

    Smith Michael smithm$

    Steele Andy steelea$

    Green Arnold greena$

    Chan Michael chanm

    Mitchell Ryan mitchell$r

    Lee Joe lee$j

    Lee Sam lees

  • December 12, 2007 at 12:04 pm

    #759539

    Check out String Functions in BOL.

    You would do something like this:

    update table set Username = replace(Username,'$','')

  • December 13, 2007 at 2:26 pm

    #760024

    Thanks AVB....It works for me.

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

You must be logged in to reply to this topic. Login to reply