Hi Cetin this was missing the bold part.

>select padd1 as address1, padd2 as address2, pcity as city, pState as state ;
> from myTable where !empty(pState) ;
>union ;
>select tadd1 as address1, tadd2 as address2, tcity as city, tState as state ;
> from myTable where !empty(tState) AND !(LOWER(ALLTRIM(tState)) == LOWER(ALLTRIM(PState))) ;
>into cursor myCursor
>
>Cetin