ISNULL Operator equivelant from SQL Server

[Nathan Pledger]

Hi,

Am fed up of my hosting providers SQL Server performance, so am migrating to MySQL. I'm sure thats good news to all!

Anyway, while I have a good grasp of SQL, I do not have a good grasp of MySQL having only worked with it tentatively and fleetingly in the past.

I have a query similar to:

SELECT Col1,Col2,Col3,ISNULL(ColThatMayBeNull,ColToUseIfColIsNull) AS NiceCol FROM SomeTable

In MS SQL, ISNULL is used to substitute a column return value with an alternative value or column if the value is NULL. This will allow me to substitute a 'default value' that has been defined elsewhere.

However, MySQL ISNULL only accepts one argument. So how can I achieve a similar result?

My MySQL Version is 4.0

Many thanks.