LIKE problem

[Alejandra Parra]

h_anagra H0014
1/1
10/10
1024514785/PAIA811014
1234567890/PAIA810909
654/654
NSSTT000/TTTTT00000
124/1421
154/154
NSS002/CURP002
2001/2001
2002/2002
2003/2003
2004/2004
2005/2005
NSS2010/CURP2010
NSS2011/CURP2011
2/2
NSS003/CURP003
321/321
456/456
4561/4561
4814124512/PAIA811014
50015001/TRIE5001
654/654
LKJH/LKJH
lkj/lkj
213/123
lkj/lkj
321/lkj
654/654
321/123
321/321
321/321
321/321
321/321
894/84
654/POI
321/15487
654/456
654/654684
654/654654
654/65489
654/654
984/89451
654/321548
32165/23151
321/154875
HOLA/HOLA
DOS/CURP
TRES/TRES
./.
KJH/KJH
789/789
98/987


I have this query

SELECT h_anagra.H0014
FROM h_anagra
WHERE (((h_anagra.H0014) Like '%CURP%'));

and it doesn't bring anything back.... what's wrong?

 

[Ken Snell]

If you're running the query in a Jet database, change % wildcard to *
wilcard character.

 

[Alejandra Parra]

ok thanks, that was really helpful

If you're running the query in a Jet database, change % wildcard to *
wilcard character.