actually ... the correct answer may not be that correct at all :hehe:

It all depends on your ANSI_PADDING setting in use.

set ansi_padding off ;

declare @Vchar varchar(12)='prasad '

, @Char char(12)='prasad '

select len(@Vchar)

, len(@Char)

, len(reverse(@Vchar))

, len(reverse(@Char))

Result:

----------- ----------- ----------- -----------

6 6 8 6

(1 row(s) affected)

But, as stated in BOL for SQL2012:

So the questions correct answer can still be accepted as valid after all.