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?????????
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)