Hi Larry
What syntax did you use and what type of remote database are you using? Logicals don't translate too well with some back-end databases, consider using a single character instead or a single-place numeric.
>The SPACE(X) worked for the char column, but for the logical column I gat a "connectivity error, syntax bad near AS'...or something like it
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05