How do i pass the linked Server name in as a parameter when using openquery
eg i want to pass in the name of the linked server as a parameter
/******************************************
DECLARE @LINKED_SERVER_NAME AS VARCHAR(50)
SELECT *
OPENQUERY(@LINKED_SERVER_NAME,'SELECT "OFFICER-CODE", "FORENAME", "SURNAME", "TELEPHONE" FROM PUB."IH_OFFICER" ')LIVE_OFFICER
/*************************************************
i can not use execute as this forms part of a larger piece of SQL which will be joined to SQL Server tables.
The linked Server Name changes depending on the customers sites (Database are the same)