> You can do it without the join like this: > > select date, mileage, notes, notes like '%whatever%' as match from m; Oh sweet, did not know I get the query to be that simple! I'm glad I asked, my long OUTER JOIN is now only a few characters long, thanks all! ted