matching different lecht numbers

C

confussed

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
 
D

Duane Hookom

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.
 
C

confussed

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...
 
Top