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