>Check Knowledge Base Article Q99095.
>
>It explains workarounds on NULL values for FoxDos.
Thanks Ken but that appears to be something different than NULL. Access and VFP support true NULL values where FP only supported empty or blank values. This is the reason I suggested NVL(). You can use it to translate NULL values into empty values.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao