Posted by strawberry on 06/03/06 14:27

Oops,

I think I meant

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

but anyway, this is probably more appropriate:

SELECT title,coalesce(season,NULL,'undefined') season FROM movies;


strawberry wrote:
> 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]