Making a substring compare between two tables 1

[rilkyn]

Dear all

I have two tables with a matching field of between six and eight characters long.

I need to compare the two fields where the first six characters from field 1, table 1 equals the equivelent in table 2. This is because the first six characters are unique with the remaining two characters being version numbers.

So:

Display table 1, column 1 where first six characters of table 1 = first six characters of table 2, column 1.

Can you help

Thanks
Rilkyn

 

[SkipVought]

Hi,

[tt]
Where left([Field1],6)=left([Field2],6)
[/tt]


Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[rilkyn]

Thanks for the quick response. I will give it a go and let you know.

Rilkyn