how to know how column values will ends with comma

Question

Hi  I have column like TName TID Mas 5263856 Nag 4256 Halen 265326 i want to find the which TName Having the TID value ends with

Rajeev Punhani · Answer

Hi Manohar select TName from table where RIGHT(RTRIM(TID) 1) =''

Amit Singh · Answer

Hey you can use STUFF() function