image data type

Hi,

In my SQL Server 2000, I have a Table MyUser which has one colum PassWord,
and the PassWord's datatype is Image. I'm wondering how can a password be
an image.
Thanks for help.

JasonI'm guessing it's because the password is actually a binary hash or
encrypted version of the password. It would probably make more sense to use
a BINARY/VARBINARY column though.

--
David Portas
SQL Server MVP
--

"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:dhvjlf$1sk$1@.news.seed.net.tw...
> Hi,
> In my SQL Server 2000, I have a Table MyUser which has one colum PassWord,
> and the PassWord's datatype is Image. I'm wondering how can a password be
> an image.
> Thanks for help.
> Jason