>Sounds you want something like:
>>SELECT NVL(a.drwno,'') AS drwno,NVL(a.revno,'') AS rev,;
>DTOC(transmittallog.date) AS date ;
>FROM transmittallog ;
>LEFT JOIN issuehistory a ;
>ON transmittallog.transno = a.transno ;
> WHERE !DELETED() AND (iscode=='A' OR iscode=='B') ;
> AND revno = (select MAX(revno) FROM issuehistory b WHERE a.drwno = b.drwno) ;
>ORDER BY drwno,rev,date ;
>INTO CURSOR curApprovalIssue
>
CetinOne small addition I'd like to make is the use of CAST() in VFP9 to make sure you get the proper column width in the resulting SQL Cursor:
SELECT CAST(NVL(a.drwno,''),C(10)) AS drwno,
...
In previous versions you can also do NVL(a.drwno,SPACE(10))
Else you could get a one-char wide column when all you wanted is to replace nulls with the proper number of spaces.
Just .02
