Andrew,
There's probably a way to get at the two different RowVersions of a Row (the original and the modified), but off the top of my head, I don't know how to do it ... I'd need to experiment. What I suggest in lieu of that is this: When the user logs in, store their encrypted password somewhere (a static property or however you're used to doing that sort of thing). Then, compare that value to the password prior to saving the row. If it's different, then you'll know that the user changed it and you can encrypt and save.
~~Bonnie
>Hi Bonnie,
>
>Thanks for the reply but the encryption algorithm is one-way only, I cannot decrypt the password (our user data is ported from an existing database so we have to use the same encryption algorithm that it used in order to allow our clients to keep their logins). To authenticate the user we encrypt the password given by the user at login and compare it to the encrypted password stored in the database.
>
>Sincerely,
>
>Andrew Fuller