Thanks Adam!
>SELECT IIF(ISNULL(TABLE.date),{//},TABLE.date) AS Boldate
>
>or if it's a char field with len(25)
>
>SELECT IIF(ISNULL(TABLE.value),space(25),TABLE.value) AS cval
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain