Hi,
Anyone can help with the following:
I have a table with a varchar field in the form of AB, CD, EF, RT
I would like to make the following a query
SELECT OPTIONS FROM TABLEX WHERE OPTIONS IN (AB,RT);
And the result should show all the rows with the filed OPTION
containing:
AB and RT (like in AB,RT,WZ)
AB and RT (like in AB,CC, FF,RT)
AB, or RT (like in AB,CD,EF or CF,RT,TT,ZE)
Any help, guidence is apreciated.
Thanks
Billy
I am using Interbase 6.


|