Wildcards

  • Thread starter Thread starter Brent
  • Start date Start date
B

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
 
Brent said:
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.
Click to expand...


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
 
Thanks


Marshall Barton said:
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
Click to expand...
 
Back
Top