= 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
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
Hi All
I am currently in the process of converting our database from Oracle to
MySql.
I Use 3.23.50 Max on Win 2k
Well..here's a query where we use decode function in oracle...How do i
change it to MYSQL
The Query is
-
