Problem In Executing A Dynamic Sql.

Hi All,

I am facing a problem in a dynamic sql query. My query is

EXEC
('
SELECT A.Atm_Model, CU.Credit_Union_Name,
CASE WHEN LICENSED_SERVICES_NAME=''VISA'' THEN 1 ELSE 0 END AS "VISA",
CASE WHEN LICENSED_SERVICES_NAME=''PLUS'' THEN 1 ELSE 0 END AS "PLUS",
A.Atm_Make
FROM ATM A
LEFT JOIN Credit_Union CU ON CU.Credit_Union_ID=A.Credit_Union_ID
LEFT JOIN Credit_Union_Licensed_Services CULS ON CU.Credit_Union_ID=CULS.Credit_Union_ID
LEFT JOIN Licensed_Services LS ON LS.Licensed_Services_ID=CULS.Licensed_Services_ID
')


when i execute this query it works fine but when i try to execute the following query

DECLARE @VAR VARCHAR(MAX)
DECLARE @VAR1 VARCHAR(MAX)

SET @VAR=dbo.DYN()
SET @VAR1=('SELECT A.Atm_Model, CU.Credit_Union_Name, '+@VAR+' A.Atm_Make
FROM ATM A
LEFT JOIN Credit_Union CU ON CU.Credit_Union_ID=A.Credit_Union_ID
LEFT JOIN Credit_Union_Licensed_Services CULS ON CU.Credit_Union_ID=CULS.Credit_Union_ID
LEFT JOIN Licensed_Services LS ON LS.Licensed_Services_ID=CULS.Licensed_Services_ID')
EXEC (@VAR1)


it throws an error that "Incorrect syntax near VISA"

dbo.DYN is a function that writes string
CASE WHEN LICENSED_SERVICES_NAME=''VISA'' THEN 1 ELSE 0 END AS "VISA",

CASE WHEN LICENSED_SERVICES_NAME=''PLUS'' THEN 1 ELSE 0 END AS "PLUS",

can you please help me in this?

Thanks
Ashutosh