Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dcores
Starting Member
3 Posts |
 Posted - 2003-02-17 : 12:39:11
|
| Howdie dudes en dudettes!I was wonderingI have very simpel query:SELECT zoekcode, samennaamFROM lidWHERE zoekcode LIKE 'SPAA%';(I'm dutch so now you know why the table name etc is rather strange)ok, looked in the table LID and i saw that there's a record: SPAA 6my intention with this query is to get al the records where zoekcode starts with SPAA.I'm 100% positive that the query is OK. I changed the position of the % but nothing works!could this be a bug in ACCES 2000thanks!!Leter!D |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-02-17 : 13:59:24
|
| Access uses "*" as the wildcard character for the LIKE operator, just like VB; this is the equivalent of the "%" from SQL you are trying to use.Also, "?" is the equivalent in Access/VB of the "_" character.- Jeff |
 |
|
|
|
|
|
Acces 2000 and bugs