Re: Problem with NULL values

I really do not like INFORMIX. You know Oracle? Oracle provides a NVL function. You can create a stored-procedure to simulate NVL in INFORMIX, it won't take you much time. Colin Thu wrote in message ... >Dear friends! > >I have some problem with my Query (SQL). It's about NULL values. > >SELECT ordernro, quantity, sent, (quantity - sent ) as 'q_left' >FROM orders> >So, If sent = NULL then (quatity - sent) is not "quantity". It'll become >NULL too. So, I need the real value for "q_left". > >Thanks for people =P > >