SQL Image Data type

[mtl77]

Hi Everyone,

I have a image data type column that contains several different types of files, word docs, gifs, jpeg, pdf's and so on. In order to enable these files to be viewed through an asp.net page i need to know the file size and type. The db was created by someone else and this info was not stored seperatly. Is there anyway to extract that info from the binary image datatype?

Appreciate any help.

KF

 

[nigelrivett]

As far as the database is concerend this is just a series of bits.
To get a file type you have to get some identifier that the app writes to each file it creates - and hope that no one has put anything in the database which has that identifier but a different format.



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.