SQL Server Query

Question

Hi friends,
                I want know that , How to get names having '_' at the and of names in the tables. and remove the '_' from the names having '_' at the ends of names in the table. like deepak_ to deepak. ?

Thanks