Hi Martijn

Thanks I will keep this in mind. I had generally used ISNULL() in VFP
and SQL Server so I had completely forgotten this method

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> Hi,
>
> > What is the equiv. of IsNull() in FireBird. I want to check if a
> > value is null in the WHERE clause of a SELECT statement.
>
> If you want to check for NULL, why don't you just use:
>
> WHERE mycolumn IS NULL
>
> ?
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,

Oracle &

> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>