what about this query->select Name+',' from Fruit Order By Id for xml path('')

Thank u.it's very very useful & time saving for the developers.

SET CONCAT_NULL_YIELDS_NULL ON

SELECT ISNULL('abcd'+NULL+1,'1234567890')

if i add any numeric value then it gives->1234567890 why?

i think there is something wrong with this answer coz it should be

-1,0,1 but ans is -1,-2,-3.