RE: Problem with NULL values

Or if you are at a late enough release you can use NVL which is part of Informix Will >===== Original Message From "Harry Sheng" <hsheng@crosskeys.com> ===== >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 >> >> ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------