Query with LIke Statement

[Tausif Alam]

Hi All,
I am running folloowing query, but it is not picking up any record. Could
you please tell me is there any mistake I did.

The Field ChangeRequest is TEXT(255)

SELECT transactions.Priority, transactions.ID, transactions.[Problem No] as
TicketNo, transactions.Company, transactions.Media, transactions.[Date
Request] as DateRequest, transactions.[Support area] as SupportArea,
transactions.ProblemDesc, transactions.Consultant1,
transactions.Consultant2, transactions.Consultant3, transactions.[Assigned
to] as assignedto, transactions.CompleteDate, transactions.Status,
transactions.billable, transactions.ChangeRequest FROM transactions WHERE
1=1 AND transactions.ChangeRequest like ('%E%');

Thankx.

Tausif

 

[Allen Browne]

If the data is stored in Access tables, use the asterisk as the wildcard,
i.e.:
WHERE transactions.ChangeRequest LIKE '*E*';

 

[gandalf]

if this is an "ACCESS"-query you have to use * instead of
% as wildcard