Limiting records

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
 
M

[MVP] S.Clark

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

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

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