Mark:
If I have the following statement:

lcSQL = "Select clClientID from CLIENTTYPE where clClientID = '" + lcID + "'"

can I then use this command:

sqlexec(gnconn,lcSql,"mycursor")

when I do that it returns empty set, but if put the sql statement in SQLEXEC then it works. My extact codes are:
m.client_id = TEST.CLIENT
clSQL = init_val.sql_str
sqlexec(gnconn,lcSql,"mycursor")
I tried to put alltrim around init_val.sql_str, it did not work. I copied the content from init_val.sql_str and pasted in the SQLEXEC. It works. any idea on that? thanks
sherry