The use of "Like"

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

I just want to make my query to look in the memo field name "Note1", the
records that has a content of "Jatimulia", but it seems it can not work.
Anyone can help me?.

This is my query:
SELECT *
FROM BukuAngKbyQuery
WHERE (((BukuAngKbyQuery.STAT_CODE)="A") AND ((BukuAngKbyQuery.Note1) Like
'*" Jatimulia & "*'))
ORDER BY BukuAngKbyQuery.NO_URTANGT;


Thanks in advance,

Frank
 
Back
Top