Unsure of logical operators

[jimoharry]

Hey

Can someone answer me if Like "Red" and Like "Blue" Or Like "Red" is a logical operator?

Thanks for the help

 

[gemma-the-husky]

like "red" is a bit meaningless without optional placeholders

ie like "*red*" will return everyting with red anywhwhere in the string

like "red" will only return the value "red", so it is the same as ="red"

----------------
however to answer your question

"red" or "blue", is a boolean test (ie a true or false result) but in a query it will return the string itself.

if you actually want to return a true or false value then you need to define the column in the query as eg iif("red", true, iif("blue",true,false)).

i'm not sure if you can use the in operator (available in some languages) here as in the syntax

iif(in("red","blue"),true, false)

i'm also not sure whether you can use like within this statement - you might instead need to use instr to examine the string.