## AVG function

 Author Message krishnaroopa Old Hand Group: General Forum Members Points: 319 Visits: 183 Comments posted to this topic are about the item AVG function Gobikannan SSCrazy Group: General Forum Members Points: 2362 Visits: 614 Simple QotD today. ----------------- Gobikannan M&M SSCrazy Eights Group: General Forum Members Points: 9770 Visits: 3916 Thank you Krishna M&M paul s-306273 SSCarpal Tunnel Group: General Forum Members Points: 4705 Visits: 1224 Nicee and easy if you read the question properly... Britt Cluff SSCrazy Group: General Forum Members Points: 2905 Visits: 253 Easy question if you don't talk yourself into thinking it's a trick question. http://brittcluff.blogspot.com/ Mike Palecek Ten Centuries Group: General Forum Members Points: 1026 Visits: 823 I made the same mistake I make all the time and forget about the datatypes.Good Question to make you think. Daniel Bowlin SSChampion Group: General Forum Members Points: 13654 Visits: 2629 Good question. Thanks. Mike Byrd Old Hand Group: General Forum Members Points: 329 Visits: 389 Makes it even more interesting if you add following:insert into @test values ( NULL )Answer is still 6. Mike Byrd ronmoses SSCrazy Group: General Forum Members Points: 2190 Visits: 1021 Mike Byrd (6/21/2011)Makes it even more interesting if you add following:insert into @test values ( NULL )Answer is still 6.Because aggregate functions ignore NULLs, right?Good question today, thanks. I had it nailed on theory and then almost got it wrong by screwing up the math. 24 divided by 4 is NOT 8, duh. Tuesday morning brain, I guess.ron -----a haiku...NULL is not zeroNULL is not an empty stringNULL is the unknown SanDroid Hall of Fame Group: General Forum Members Points: 3696 Visits: 1046 Britt Cluff (6/21/2011)Easy question if you don't talk yourself into thinking it's a trick question.I have noticed that thier have not been any question that could be confused as a "Trick Question" in a LONG time. :-PThank you Steve! :-D