Thanks Dan, the <> worked just great......

"Dan Bracuk" <webforumsuser@macromedia.com> wrote in message
news:g67ofl$j26$1@forums.macromedia.com...
> Your specific error comes from the word "not". It should be either <> ",
> is
> not null", or both, depending on how you store your data.
>
> There may be some other issues, depending on what the values of form.sql
> and
> Search1 are.
>
>
>