Jamie Longstreet-481950 (7/17/2010)

---

Could call it a trick... in another form:

select * from(

select 'red'

union select 'red'

union select 'blue'

union select 'green'

union select 'yellow'

union select 'orange'

union select 'purple')x

where textfield like 'red' -- or like '%red%' same thing

In the above form, it's obvious we have no field named "textfield".