{Resolved} A CASE statement looking for NULL

[dbelley_office]

Hi,

I try to do this:

		CASE HAE1.idStatutEmploi
			WHEN NULL THEN 'Employeur'
			ELSE 'Profil emploi' 
		END AS TypeAdresse,

It never set the field TypeAdresse to "Employeur", but it should, I have many HAE1.idStatutEmploi set at NULL in my database.

I guess my code is just not efficient.




EDIT:
OK .. found it.

		CASE 
			WHEN HAE1.idStatutEmploi IS NULL THEN 'Employeur'
			ELSE 'Profil emploi' 
		END AS TypeAdresse,