2nd query I'm stuck on

[tdion]

I would like to query for items similar to

SELECT crayon FROM box WHERE color IN ('red', 'blue', 'green')

However, I instead I would like to query for LIKE... ORing them as above.

SELECT crayon FROM box WHERE color LIKE IN ('r*', 'b*', 'g*')

Is the statement above right?

 

[lespaul]

I don't think that syntax will work. It will need to be:'

SELECT crayon FROM box WHERE color like 'red*' or color like 'blue*' or color like 'green*'

Leslie

 

[tdion]

Thanks Leslie. Does anyone else have any suggestions? I have a lot of LIKEs to OR and am looking for less keystrokes than mentioned.

 

[Zonie32]

If you put in your query grid in the criteria section
Like "[RBG]*" it will return all colors that begin with these letters. Is that what you are after?