hi,

if you see table creation syntax ,i m using A varchar(40) instead of A varchar

below queries resluts same but WHY????

CREATE

TABLE #TEST(A varchar(40),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));