Variable where

[Aldemarprins4]

Hi guys, I have the following problem, I have a where statement, but I want to include it in a variable, the statement is this

Where Date> = '$ (DateC)' and FlagoneFX = 1;

How can I include this statement in a variable?

Thanks

[Saravanan_Desingh]

So DateC is again a Variable here?

[Aldemarprins4]

Hello, yes DateC is other Variable, 

What I want to do is that when, you have a variable X, do the where with the variable DateC and and FlagoneFX = 1, if the variable is different from X then do

where DateC y and FlagoneFX = 1 and Flagbg = 1

[Arroyo45]

when i use those variable in where clause(sql query) its not giving output and if i hardcode those vaiable values output will come.

liteblue