matching different lecht numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have any idea how to match different lenght numbers in a query?
For example:
From one part of my query the number is FH770BSHG
The number on the other part of the query would be FH770BSHG651C78CHJ
Is there away to get the query to read from left to right and stop when it
matches the number by the fist 9 digits?
Thanks
 
If you are always looking for the first 9 then use Left([YourLongerField],
9)
You can also use Like to match one field value contained in another field
value.
 
Thanks;
I'll let you know how I make out.

Duane Hookom said:
If you are always looking for the first 9 then use Left([YourLongerField],
9)
You can also use Like to match one field value contained in another field
value.

--
Duane Hookom
MS Access MVP


confussed said:
Does anyone have any idea how to match different lenght numbers in a
query?
For example:
From one part of my query the number is FH770BSHG
The number on the other part of the query would be FH770BSHG651C78CHJ
Is there away to get the query to read from left to right and stop when it
matches the number by the fist 9 digits?
Thanks
Click to expand...
Click to expand...
 
Back
Top