Gerald,
God, it getting scary now, I'm actually starting to grasp all this stuff now.
this is exactly what I came with last nite, but just didn't understand what your
idea was when I first read it. :) This appears to be the best solution.
Thanks for your help,
Cheers,
>>On Wed, 11 Jul 2001 12
t2 has a line for each of the multiple IDs
MYKEY ID
---
key1 IM34456
key1 IM34457
key1 IM34458
key2 IM34457
key2 IM34567
...
t1 would have lines like ( using your fields instead of name,addr,city )
MYKEY NAME ADDR CITY
- - - -
key1 name1 addr1 city1
ke
Gerald,
You lost me on the second table, t2?? The t1 table would store a 'mykey' and the
multiple values(ID's) and table t2 would have the reference 'mykey' to table t1
and the ID column,... this is where you loose me??
>>On Wed, 11 Jul 2001 08:26:11 -0500, Gerald Clark <[EMAIL PROTECTED]>
>
Use another table to hold these values.
This table contains the ID that you are searching on and the key
to the other table that contains the rest of the data.
t1 : mykey , field1, field2, field3, field4 .
t2 : mykey , ID
Select * from t1,t2 where t1.mykey = t2.mykey and t2.ID="IM34485";
|| ID
like '%,$value,%' || ID like '%,$value'
-
Regards,
Rod~
> -Original Message-
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of MikeBlezien
> Sent: Tuesday, July 10, 2001 10:50 PM
> To: Rodrigo
Thanks, but this won't work, we need an exact match of one of the multiple
values, if there is one exact match of any of the values within the column, then
we pull that row out to be displayed. so it has to be an exact match.
>>On Tue, 10 Jul 2001 23:05:02 -0500, "Rodrigo Zerlotti" <[EMAIL PROTEC
select ID from TABLE_NAME where ID like '%value%'
or I misunderstood the question.
-
Regards,
Rod~
> -Original Message-
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of MikeBlezien
> Sent: Tuesday, July 10, 2001 10:38 PM
> To: [EMA
