Limiting records

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

Frank

Hi,

I am trying to create a query that would limit the records to those with
code that starts with example 'APGU'. When I use the SQL word LIKE I don't
get any results. If I use the complete code "LIKE 'APGU-006' It would return
that record. Can anyone help me to create this query. This is what I have:
SELECT karmas.IdArticulo
FROM karmas
WHERE (((karmas.IdArticulo) Like 'APGU'));

Frank
 
You need to add a wildcard operator.
WHERE (((karmas.IdArticulo) Like 'APGU*'));

WHERE (((karmas.IdArticulo) Like '*APGU*'));

WHERE (((karmas.IdArticulo) Like '*APGU'));
 
Back
Top