Operators

[DanHD]

hello

in tsql I use operators like:
"where fieldname in (2,5)"
in this case I only get 2 and 5
or
"where fieldname <> (2,5)"
in this case I only gets the value not equel to 2 and 5.

How works this in Crystal? Now I need to repeat the where clausule, like:
"where fieldname 2 or where fieldname = 5".

This can be easier, isn't it?

Dan

 

[kray4660]

if you are using a parameter, use the 'One of', it basically translates to an 'in' statement. {fieldname} in [2,5] unless the field is a string then there would be double quotes around the values.

 

[DanHD]

thanks

it works.
I didn't about the [] characters.

Dan