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.

--
Duane Hookom
MS Access MVP


"confussed" <(E-Mail Removed)> wrote in message
news:FE2B39B2-3FF5-4841-9179-(E-Mail Removed)...
> 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

Thanks;
I'll let you know how I make out.

"Duane Hookom" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:FE2B39B2-3FF5-4841-9179-(E-Mail Removed)...
> > 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
>
>
>