BLOB field file types
My company's SQL Server 2000 database has a field which may store BMP or text files.
I want to use an ASP file to retrieve these files, but I don't know how (or if it's possible) to "sniff" the content type of the file in the BLOB, so I can choose the appropriate contenttype setting when the file is retrieved.
Can anyone help? Is this possible, and if so, sample code would be much appreciated.
Thanks in advance,