[thelist] MS Access query
rudy
Rudy_Limeback at maritimelife.ca
Thu Nov 16 14:45:21 CST 2000
> Table2.Title may have additional text in parentheses
> at the end. For example:
>
> Table1.Title = "The cow jumped over the moon"
> Table2.Title = "The cow jumped over the moon (really)"
hi david
if the two strings really are the same at the front, all you have to do is
determine the minimum length you want them to be equal, then use the
microsoft access Left$ function
SELECT Table1.Title
FROM Table1, Table2
WHERE Left$(Table1.Title,21) = Left$(Table2.Title,21)
adjust 21 to the minimum length you want
rudy
r937.com
More information about the thelist
mailing list