Test for a NULL variable

[neilc]

I am porting a number of MSSQL stored procedures to MYSQL. How do I simulate testing for a NULL variable? In MSSQL it is:

IF Number IS NULL
BEGIN
SET Number = 0;
END IF;

This does not work in MySQL however (syntax error).

Thanks in advance.