I've done this for different applications for over two decades now....and despite the advances that SQL Server has made with newer data types (like the FileType in sql2012), I really prefer a good old fashioned approach of storing the images in shared folders with a table catalog. SSRS (and other report writers, including the VFP report writer) have ways to show images dynamically in a report. If you want to describe your situation with some specifics, I'm sure there are a few people who can offer good suggestions.

I have used that approach as well for images and display the image in an image control. To show the image / document I just use ShellExecute


>Hi!
>
>I have a table that holds data for the company's customers, and I need to store the id card for each one of them. So, I wonder what the best way is to store .jpg or .pdf files and how it can be done with Visual FoxPro 9 connected to the SQL Server Table. And then how to show the .jpg or .pdf files within my Visual FoxPro application.
>
>Thanks in advance.
>
>Luis