Wildcards

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brent - 09 Feb 2005 01:52 GMT

I have a table I want to look for matching records in. One of the options
that data entry people have is to enter wildcards into records if they can't
read the ID# off of a receipt. I want to be able to match records that use
the wildcards as a criteria. i.e. once record says 12345 and another record
is 12?45.

any ideas.

Brent

Reply to this Message

Marshall Barton - 09 Feb 2005 16:46 GMT

>I have a table I want to look for matching records in. One of the options
>that data entry people have is to enter wildcards into records if they can't
>read the ID# off of a receipt. I want to be able to match records that use
>the wildcards as a criteria. i.e. once record says 12345 and another record
>is 12?45.

I think this kind of thing will do that.

SELECT table.ID, T.ID As Match
FROM table INNER JOIN table AS T
ON T.ID Like table.ID
WHERE table.ID <> T.ID

Signature

Marsh
MVP [MS Access]

Reply to this Message

Brent - 09 Feb 2005 18:55 GMT

Thanks

>>I have a table I want to look for matching records in. One of the
>>options
[quoted text clipped - 12 lines]
> ON T.ID Like table.ID
> WHERE table.ID <> T.ID

Reply to this Message