I guess you meant a varbinary(max) column?

As far as i know you can't do it in TSQL only, you would need to use a tool or an application to read it from the table and write it to disk, or you could write a CLR that does just that.

You can give it a shot with bcp.exe, but it might write extra stuffs (like header info, length, etc...) and you might not end up with just the JPG.