SQL Server - What is the mistake in here i tried many times but i can't find answer

Asked By Mano on 26-Jul-10 07:28 AM
this is a table i have created it has some values but when i try to retrieve values by using this

 "      select right(Eventid,4) from cat      " but its not working instead it shows blank values in the column

create table Cat
    EventID char (20) primary key,
    evendes varchar(50) null

Jaya Nehru Kumar replied to Mano on 26-Jul-10 07:38 AM
because of empty spaces it doesn't show the value
try the following , it will trim the empty spaces if any
 select right(rtrim(ltrim(Eventid)),4) from cat