oops - I had a stray SELECT - I have edited the post.

You could still use SET - since you simply filling a variable with a value.