• I did it but it returns 4,4,3. So the answer was wrong!

    set ansi_padding on;

    go

    create table #q (v varchar(5) );

    go

    insert into #q

    select 'ABC' UNION ALL

    select 'ABC ' UNION ALL

    select 'ABC ' UNION ALL

    select 'ABC '

    select * from #q

    select COUNT(*) from #q where v = 'ABC';

    select COUNT(*) from #q where v = 'ABC ';

    select COUNT(*) from #q where v LIKE 'ABC ';

    drop table #q

    go