Sorry for posting this here. Wasnt getting enough attention in "Getting Started With SQL" forum.
I have a column MTD_PNL of type varchar(255) that may have NULL as a value along with numerical values. I want to write an sql to sum up MTD_PNL grouped by ACCT_NO
SELECT ACCT_NO, SUM(Convert(FLOAT,
GROUP BY ACCT_NO
The above SQL fails when encounters NULL.
View Complete Post