Re: Decode to Case

2002-06-05 Thread Arul
= 2) -Arul - Original Message - From: "Tommy Claasens - Q Data KZN" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 5:54 PM Subject: RE: Decode to Case > Try a function ca

RE: Decode to Case

2002-06-05 Thread Tommy Claasens - Q Data KZN
Try a function called coaleace It will return the non null value. But i dont have the exact syntax with me nor the manual. Hope it helps Tommy -Original Message- From: Arul [mailto:[EMAIL PROTECTED]] Sent: Wed, 05 Jun 2002 13:26 To: MySQL Subject: Decode to Case Hi All I am curre