criteria specifications

[Cody12345]

I have a several rows say
Location part # product code
105 E05 DX
104 1740 DX
104 2047 DX



I want a way to find a way in chriteria thet i can find all related info on these parts.
When i ran this query it only gave me the product code DX
I know you can use wild cards in queries but this is to specific and i would need all info related to the seperate part numbers if they were expanded.
is there a way to set chriteria to find all related numbers of my list using the first 3 characters, so it will give me any other part number product code that even contain say E05.

have a several rows say
Location part # product code
105 E05 DX
106 E055 RX
104 1740 DX
105 1740-567 FX
104 2047 DX

[ChipR]

You can use the LIKE condition. See examples here:
SQL: LIKE Condition

If you want to match 4 different sets of numbers like that I think you could do
WHERE id LIKE '12345%' OR id LIKE '16564% or id LIKE etc.

[Cody12345]

Ya that works the only thing is i have say 800 rows.

Is there a way to use the like for the characters in the feild with out being so specific

select *
FROM Part #
WHERE Part # LIKE ' ( say the first 4 character)

Or something that could be applied to the whole table without going throught each number?

[ChipR]

I don't understand the question. That's exactly what LIKE '1234%' does. The select is going to have to look at the part number of each record in the table regardless.

[FishVal]

Hello, Cody.

You could try join the datasets on partial match.

SELECT [AllRecords].* FROM [AllRecords] INNER JOIN [SeveralRows] ON [AllRecords].[part #] Like '*' & [SeveralRows].[part #] & '*';

[Cody12345]

ya i understand that but i want the like'12345%' of all 800 part numbers... meaning.....

If i have all of the part numbers below i want the like'E05%', and the like'1740%' and the like'2047%' and so on and so on for all 800 part numbers.

E05
1740
2047
4521
21601
BM153
BM495
BM752
FCE45
FXD28
2248
2433

[Cody12345]

thanks fishval ill try that!