{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,

[DKenny]

Id this in a vb proc or in an SQL statement?

If it is in an SQL statement it should be

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