ASP operands

[davmold]

I am still learing ASP

I know you can do a <, >, =, etc.

but how could you do a between for example I would like to take the numbers between 1 and 7 can this be done with asp?

thank you

 

[monksnake]

Like this:

a > 1 and a < 7

There is no direct 'between' operand.

<.

 

[travisbrown]

Although, if you wanted it to match the T-SQL BETWEEN operand, you'd use a >= 1 AND a <= 7.

BETWEEN includes the outer bounds.

I wish ASP had a BETWEEN operand.

 

[xwb]

Depends on how you think. Some people like the a on the left, some on the right, some on the inside and some on the outside. Just a matter of style.

a > 1 and a < 7  ' on the left
a > 1 and 7 > a  ' on the outside
1 < a and a < 7  ' on the inside
1 < a and 7 > a  ' on the right