[RESOLVED] ISNULL() problem

[mrbaseball34]

SELECT CASE ISNULL(file_format) WHEN 1 THEN file_format ELSE '' END;
FROM user_directory WHERE user_id=32

The code above returns error: Unknown column 'file_format' in 'field list'
even though the column IS in the table and populated for that user_id.
What am I doing wrong?

[mrbaseball34]

SELECT CASE file_format WHEN NULL THEN '' ELSE file_format END 
FROM linv_user_directory WHERE user_id = 32

DUH!!!

[bradgrafelman]

Seems like you don't want NULL values... is that true for every instance where you deal with this data? If so, why not declare the field as NOT NULL DEFAULT '' instead then?

[mrbaseball34]

because the table is already populated and adding the column is all I can do right now.