CREATE TABLE #TEST(A varchar,B varchar(30));

INSERT INTO #TEST(A) VALUES('A');

INSERT INTO #TEST(B) VALUES('Some text');

INSERT INTO #TEST(A) VALUES('B');

INSERT INTO #TEST(B) VALUES('Some more text');

SELECT COUNT(*)FROM #TEST GROUP BY LEN(ISNULL(B,A));

go

SELECT COUNT(*) from #TEST GROUP BY LEN(ISNULL(A,B));

Why above queries are giving differentt results?????????