It's handy syntax. just a reminder for myself, as I don't use sql often.

[sourcecode language="sql"]
UPDATE [SiteUsr]
SET HashAlgorithm =
CASE WHEN LEN(PwdHsh) <= 32
THEN 'MD5'
ELSE 'SHA1'
END

[/sourcecode]


Andrew Chaa

another day, another PR