Posted by strawberry on 06/03/06 12:36

Does this work?

SELECT title,replace(ISNULL(hint),'1','Undefined') FROM movies;

Goomba wrote:
> i am trying find whether or not a value in a field is null, but i keep
> coming up with 'wrong number of arguments' error. as far as i am aware, the
> isnull function takes two arguments, and those i have defined. im not sure
> what else is wrong.
>
> SELECT title, isnull(season, 'undefined') as season
> FROM movies
>
> the database im using is MS Access 2002.
>
> thanks for any input!

[Back to original message]