Executing A UDF On A Linked Server

Hello.

Is there a way to execute a user-defined function as part of a select query on a linked server?

Here is the query that won't work because the function it calls is on a remote server (and the way I have called it is also incorrect I know, it's just to give an idea of what I'm trying to achieve).

SELECT a.[Member Number],


a.SchemeID,



b.Scheme,

Atlantis.ptr.dbo.upFUNMemberStatusOnADate(a.[Member Number],'01/10/2007 00:00:00.000') AS Category,


a.[Employer Number],



c.[Employer Name]
FROM Atlantis.ptr.dbo.Member a

JOIN Atlantis.ptr.dbo.Scheme b

ON a.SchemeID = b.SchemeID

JOIN Atlantis.ptr.dbo.Employer c

ON a.[Employer Number] = c.[Employer Number]


Apologies for the formatting of the query. I have looked at the EXECUTE query in BOL but it doesn't seem to be able to work as part of a SELECT, I'll keep looking though but I'm hoping someone might know the answer straight away.

Thanks