One way could be to use
exist
. For example
SELECT * FROM #MyTable WHERE Data.exist('/EMPLOYEE/RECORD[@ID="7"]') = 1
ADDITION
One way is to build the statement dynamically. Consider the following
DECLARE @myVar INT = 7
DECLARE @sql NVARCHAR(1000)
SET @sql = 'SELECT * FROM #MyTable WHERE Data.exist(''/EMPLOYEE/RECORD[@ID="' + CAST(@myVar AS VARCHAR(100)) + '"]'') = 1'
PRINT @SQL
EXECUTE sp_executesql @stmt = @sql