>Hi everybody,
>
>We're running simple sqlexec('select * from myTable', 'myCursor') command and the resulting field is a general field. How can we find out what is the field type in SQL Server and is there a way to get this field in other type?
>
VFP uses zero workarea as a template.

=CURSORSETPROP("MapVarchar",.T.,0),CURSORSETPROP("MapBinary",.T.,0)

>Also after we get this as a blob, how can we find out what type of the image was there?

simple:
1. store the original file's type into the MSSQL

better:
2. check the image header

>
>Thanks a lot in advance.