Thanks that works. 🙂

set @MyVariable = MyFunction(@MyParameter) and

select @MyVariable = MyFunction(@MyParameter) gave the following error:

'MyFunction' is not a recognized built-in function name.