>

...
>Where x.ssno IS NOT NULL
>...

>>thanks for the heads up. What about if I wanted to exclude nulls in the ssno field? I wrote is several different ways but it hasn't worked for me:
>>
>>

1:  SELECT strtran(x.ssno,'-',''), x.firstname, x.lastname, x.idnumber, x.archive, y.idnumber, y.imageid ;
>>	FROM ud_tbl x INNER JOIN it_tbl y ON x.idnumber = y.idnumber AND x.ssno != null ORDER BY x.lastname INTO CURSOR test readwrite

>>
>>

2:  SELECT strtran(x.ssno,'-',''), x.firstname, x.lastname, x.idnumber, x.archive, y.idnumber, y.imageid ;
>>	FROM ud_tbl x INNER JOIN it_tbl y ON x.idnumber = y.idnumber Where x.ssno != null ORDER BY x.lastname INTO CURSOR test readwrite

>>
>>
>>both gave me blank cursor table. Must be missing something simple again.
>>
>>thanks
>>Nick

hey, thanks again Sergey. looks like i'm beginning to lose my Foxpro skills.

thanks
Nick