Close, I think this should work..
Well that was far easier than I had assumed... but leads me on to one
Given the 10 digit ISBN holds a country code within it, and there is no
indication of how many digits make up the country code... how would I do
something along the lines of:
select SomeFields from BiblFile join with Countryfile where
BiblFile.ISBN contains partial match with CountryFile.Country.
80 Czech Republic
011700001X TitleA 0 English
810115400X TitleB 1 India
922941011X TitleD 9229 Guatemala
Using your assumption of varying length fields, no trailing spaces.
I get the feeling that its something to do with joining the country file
to the bibliographic file, but in reverse - kind of.
Select SomeFields from BiblFile and CountryFile where rightjoin
(CountryFile.Country *cat '%') like Biblfile.ISBN