thanks for code.but it is giving me error Msg 536, Level 16, State 2, Line 3

Invalid length parameter passed to the RIGHT function.

I think it is beause in there are Full_name like 'james' means there is no underscore . and in some cases rather than name there is value like '655' .so for that cases i want 'james' and '655' only.