Re: Oracle NVL equivalent for MySQL?

"Dominick Vansevenant" <dv@mobyus.com> wrote: > Maybe a bit offtopic, but is there an equivalent for the NVL function in > Oracle for MySQL? > > NVL is a function that returns a given result when a value is null You do know there's a MySQL list, don't you? There's no such beast in MySQL, but you can do this: IF( my_field IS NULL, your_expression, my_field) -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/