Parameters On The Left Side Of A Where Clause Predicate

Good afternoon,

I'm trying to use a parameterin a way that RS seems to think is unnatural, and I'm wondering about a work around...

Normally I can use parameters like so:

select *
from foo
where fooValue > @myParameter

What I'd like to do instead is use a constant on the right of the predicate, and a parameter to define the column to measure against, like so:

select *
from foo
where @myParameter > 10

Or

select *
from foo
where @myParameter is not null

Any assist with this is greatly appreciated...

Thanks,
Brian