Wildcards

[Brent]

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

 

[Marshall Barton]

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

 

[Brent]

Thanks

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