On 7/26/06, João Cândido de Souza Neto <[EMAIL PROTECTED]> wrote:
Hi.
Let me explain something about coalesce.
coalesce(field,0) return 0 if the field value equals null or the field value
if it´s not null.
:-) ooo !!! ok... it's the same to do: case when field is null then
0 else field end
Than's a lot everyone !!! i didn't know it
--
http://www.obed.org.mx ---> blog
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]