Re: ADO.NET not retrieving results correctly

From: Andy (andy.goss_at_gmail.com)
Date: 02/03/05 

Date: 2 Feb 2005 19:44:28 -0800

I do not normally use Access, however is the txt you are looking for in
the like clause literally *test* or are the stars supposed to be
wildcards? If it is supposed to be 0 or any character before and after
test, try using the % instead of the * like this:

SELECT Appointments.AppointmentID, Appointments.AppointmentT­ime,
Buildings.Building, Appointments.RoomNumber, Appointments.De­tails
FROM
(Appointments INNER JOIN Buildings ON
Appointments.BuildingID=Buildings.BuildingID) INNER JOIN Tec­hnicians
ON
Appointments.TechnicianID=Technicians.TechnicianID WHERE 1 =­ 1 AND
Technicians.TechnicianName = "Matt" AND Appointments.Details­ LIKE
"%test%";

I am not sure if this is what you are looking for, however I saw the
LIKE and assumed that you were trying to do this.
Let me know if it helps --Andy

Loading