data types question

[saina]

HI,
I am very new to sql and am using TOAD. i am getting teh following error.

when m.merit is null then 0
else m.merit
end as merit

when i am trying to execute this statement i got error
INCONSISTENT TYPES EXPECTED NUMBER GOT CHAR

my question is how to set the value for m.merit zero when it is null.

 

[guelphdad]

can you show your entire query rather than part of your query? It will help us help you.

 

[r937]

could you also please mention what datatype is merit

r937.com | rudy.ca

 

[saina]

Gotit working
tahnks

 

[guelphdad]

so can you either delete the thread since there is no answer available to those who may come across the thread in the future with a similar problem OR perhaps actually post the solution to the problem?