This SQL statement returns all the correct rows from 2 tables:

--------------
SELECT DISTINCT Upload.NewsID, News.NewsID, News.UserID,Left(News.Title,255) As Title
FROM News LEFT JOIN Upload ON News.NewsID=Upload.NewsID
--------------

But when I try to search for a known term in one of the fields no records are returned:

--------------
SELECT DISTINCT Upload.NewsID, News.NewsID, News.UserID,Left(News.Title,255) As Title
FROM News LEFT JOIN Upload ON News.NewsID=Upload.NewsID

WHERE Title LIKE 'ABCD'
--------------

Have tried using News.Title, '%ABCD%' but same problem.


Any ideas?

thanks,
Mike