How to retrieve an IMAGE from SQL

I am trying to create a simple website(ASP) where a list of music titles is available from a SQL Server DataBase.
So far I have it working with Artist Name, Release & Cost. However I wish to add a picture of the artist.
My problem is how to retrieve the pictures from the SQL Server DB?
Do I have to load pictures into Database?
Do I need extra software/tools to do this?
So far I have created a new column in my table called picture and set as type image
e.g. alter table music
add picture (image) null
If I store the pictures in a folder,I presume the path to the image can be stored in the DB.
e.g. Table Music
Artist Name Release Cost Picture
Madonna Say a Prayer 10 Euro ..\images\madonna.jpeg

Is this the way? I have a little experience using ASP + SQL at college level.
Help would be appeciated, or directions to a relevant tutorial!
Thanks
I also plan to have small music downloads available for each release, if any one can point me to helpful sites etc. Thanks!

Here's a good article on using image datatypes:

http://www.sqlmag.com/Articles/Index...rticleID=20460

Jeff

Cheers I'll study the article and see what figure out, haven't been at this site before, looks like there is alot of info here.

Are you using ASP + SQL much or are you migrating away from this language, preferring to use PHP(Linux) or ASP.NET,JSP or some other language entirly?

We use ASP mostly, but are migrating to ASP.net. It seems to work best with SQL Server.

Jeff