Hi Elyse,

Try something like

SELECT IIF( ISNULL( MyField ), SPACE( MyFieldLength ), MyField ) AS MySelectField FROM ...

Bill

>I'm running into problems with NULL values appearing in my SQL SELECT queries. Is there anyway to keep NULL values out of fields in my SQL query? All of my table fields do NOT accept NULL values. It would be very difficult to go back and re-write every SQL to check every value for ISNULL(). Is there some kind of SET NULL OFF that will work for SQL-SELECT?
>
>Thanks
>Elyse