Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Pascal Delphi Databases > Use of IN state...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 963 of 988
Post > Topic >>

Use of IN statement with Interbase SQL

by a.lamalif@[EMAIL PROTECTED] Jun 5, 2007 at 02:12 PM

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.
 




 2 Posts in Topic:
Use of IN statement with Interbase SQL
a.lamalif@[EMAIL PROTECTE  2007-06-05 14:12:18 
Re: Use of IN statement with Interbase SQL
Jason King <jhking@[EM  2007-06-05 21:48:04 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 3:23:43 CDT 2008.