Select to view content in your preferred language

Help with a Query Builder expression

500
1
12-15-2012 07:00 AM
SiyangTeo
Deactivated User
Hi,

Does anyone know how to shorten the definition query below?

As you can see, all of them point to the different data within the same field. And it is quite trouble to use this expression everytime but this is the only one I know.

"Name" = 'A' OR "Name" = 'B' OR "Name" = 'C' OR "Name" = 'D'

Thanks!
Siyang
0 Kudos
1 Reply
TereseRowekamp
Deactivated User
Don't know if you've discovered this yet, but you can use IN

"Name" In ('A', 'B', 'C', 'D')
0 Kudos