i can't join columns value in one column

[alim]

Both
CommonService.January ,CommonService.February are in Decimal format

when i try this , i get january value in [CommonService Paid]

SELECT CommonService.FlatMasterID, CommonService.Flat_No, CommonService.Building_No, CommonService.Year, CommonService.January  AS [CommonService Paid]
FROM CommonService;

but when i use + with these columns i m not getting the value.. whole column become null is there any way to make it work..

please it it soon..

SELECT CommonService.FlatMasterID, CommonService.Flat_No, CommonService.Building_No, CommonService.Year, CommonService.January +CommonService.February AS [CommonService Paid]
FROM CommonService;

[is not working]


thanks
alim

 

[cjard]

is one of the columns null? anything + null = null

 

[alim]

hmm..i have solve it too.. you are right...

just have to put 0.. to get values...


thanks...