Re: A Blank Value for a Number?

On Tue, Jun 14, 2016 at 3:41 PM, Kurt Wendt Kurt_Wendt@globetax.com wrote:

OK - part of the code in the system pulls data from MS SQL. So - I was trying to mod this code - to add NULL as an option into the Select. But, I suspect I'm not doing it correctly. Was looking around in online help - but, could not quickly find the answer. So - I took a shot at trying to implement this. This is only Part of the line of code - but, you can see the attempt to define NULL: SELECT d.secid ,d.sec_name AS sec_nam ,d.coi AS issue_cnty , t.taxrate_el NULL FROM [dbo].[Dividends] as d JOIN [dbo].[Trandata] as t ON t.dividend_id = d.dividend_id

Maybe something like ...CASE WHEN t.taxrate_el = 0 THEN NULL ELSE t.taxrate_el END AS taxrate_el FROM ....