Complicated WHERE statement needs %!!! HELP!!!

[Artesha]

This is the jest of my query,,

Select *
From Prospecttbl
Where Not Exists(Select * From Membertbl Where Prospecttbl.LastName = Membertbl.LastName and Prospecttbl.FirstName=Membertbl.FirstName)

The two fields have to match identically,, well, ive imported a table where the first name and middle name is merged into one field, which makes this statement null and void,, so i need some help with separating these into two diffent separate field OR another way to match the last name and the first 3 letters of the first name,, HELP!!!

Tesha

 

[CharlesCook]

Could you do this?


Select *
From Prospecttbl
Where Not Exists(Select * From Membertbl Where Prospecttbl.LastName = Membertbl.LastName and Left(Prospecttbl.FirstName,3)=Left(Membertbl.FirstName,3))
CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining