Enterinf >, < in a report parameter

[woodyinoz]

Hi all,

I have a decimal field that I would like the user to be able to query using a report parameter.

I want them to be able to add values such as:
>10000
<10000
10000

Can this be done? I want to do this using one parameter rather than setting up 3, one for each possibility (i.e. greater than, less then, equal to).

thanks in advance,

Woody

 

[Sheco]

You could do some creative parsing in TSQL if you are talking about parameters to stored procedrues.

 

[woodyinoz]

Not parameter to stored procedures no.... Just trying to run a parameter on a table.

Is there a way of doing thins using the < and > signs on one paramter?

Woody