Change null values to "0"

[#1]

Hi Guys

I need to change null values "-" to "0". How can i do this?

Where "Css_Total" and "Cyl_Total" is from different tables, linked by the common field "Date".

Can anybody suggest a solution to this problem?

Thanks

[#2]

Thank you Karolina, great explanation. But this didn't work for me, because of the missing data and because i must consider this values to calculate the average on Last 12 months.

I'm studing to solve this using VBScript.

Thanks

[mphekin12]

You could try something like this in the LOAD script:

if((isnull(Css_Total) or Css_Total=''), 0, Css_Total) as Css_Total

[#4]

Thanks, problem solved.

[Anonymous]

why marked yourself as correct? mark that person answer correct who helped you..

[#6]

Hi Anant

My mistake, sorry for that.

Thank you

[Anonymous]