>>>I have an app that's been in use for 10 or so years that uses varbinary field to store some images and like I said it works but it sure eats up a lot of disk space....of course diskspace is cheap these days so I dunno maybe it's not such a problem anymore...:)
>
>Someone said that there's a 2GB limit on VARBINARY(max) data. Is that the limit for a row, or for the whole table?

As Naomi has already said, it's for a column. SQL Server's "limits" are so extravagant you would have to work really hard to exceed any of them. I have dealt with several companies who switched from VFP to SS specifically because of VFP's 2 GB table size limit.