I will answer my own question. ARITHABORT must be on in order that xqueries such as VALUE() work.

So I began my logon trigger code with:

set arithabort on

and it worked nicely.

Thanxs 🙂