I found the following stored procedure that really returns a lot of information about the fields in a table (lots more than the VFP SQLCOUMNS() function. One of the fields is the default value. When I run the query in the QA, I can see text values, but when I run in VFP and get the results back, it stores that field in a Memo field and is jibberish. I guessing it needs to be converted or something but I'm not sure how. Any pointers appreciated.
SQLEXEC(gnConnHandle,[exec sp_MShelpcolumns 'coDept'],'xfields')
Thanks
Kirk