Remove a $ from data field

Hello All,

Here is my employee table below with data:
EMPLOYEE
LastName FirstName UserName
Doe John doej$
Smith Lee smithl
Steele Michael steelem$
Tyler Brandon tylerb$
Green Andy greena
Scott Steve scotts$
Parks Joe parks$j
And many more

I would like to remove all $ sign in the data of UserName. Please Help!
Thanks,

Quote:

Originally Posted by questionandanswer

Hello All,

Here is my employee table below with data:
EMPLOYEE
LastName FirstName UserName
Doe John doej$
Smith Lee smithl
Steele Michael steelem$
Tyler Brandon tylerb$
Green Andy greena
Scott Steve scotts$
Parks Joe parks$j
And many more

I would like to remove all $ sign in the data of UserName. Please Help!
Thanks,

use the replace functionsql