Was interested to know more, did you get a chance to post more information anywhere?

Some links may be.

- Thanks

gkd

I am not sure why sql server 2008 returned 1, inspite of not giving the variable length.

I knew this would give a syntax error, however, I tried this and it...