Coalesce... EX:

Select Coalesce(DriverName, "No Driver Found")
From Cars

Jason

Wilson, Jeremy wrote:

> Is there a replace function that will allow text to replace null in a
> column of a select list that comes back as null.
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>