SELECT source_name FROM tblThisTable WHERE Uid = 1001 into curs tmpcurs
cName =source_name
use in tmpcurs

>How can I run a SELECT sql statement and assign the return to a variable? It's only ever going to return one value
>
>ie:
>cName = SELECT source_name FROM tblThisTable WHERE Uid = 1001
>
>Except that doesn't work.
>
>Thanks!