while using char datatype the value assigned to the @txtgrant is padded with spaces i.e. if @txtgrant = 'xyz' then it will be set to 'xyz' + 47 spaces...