By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,251 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

MS Access query returns many rows in preview but 0 on run (execute)

P: n/a
When i run the following query on my table it returns 0 rows but when i
run it in the preview mode (where the update is applied) more then 2000
records are returned.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product) Like '%station%'));

If I change the Like to be just = as below then everything works so it
seems to be something about the Like statement.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product)="station"));

Unfortunately i need to use like as Product field is a text field and
station is just a tag which may appear in it.

Any help would be greately appreciated.

Funny thing is that stuff used to work but for some reason doesn't
anymore.

I am connecting to a SQL database through ODBC & a linked table.

Jul 13 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Replace % with *


--

Terry Kreft
<ma***********@honeywell.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...
When i run the following query on my table it returns 0 rows but when i
run it in the preview mode (where the update is applied) more then 2000
records are returned.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product) Like '%station%'));

If I change the Like to be just = as below then everything works so it
seems to be something about the Like statement.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product)="station"));

Unfortunately i need to use like as Product field is a text field and
station is just a tag which may appear in it.

Any help would be greately appreciated.

Funny thing is that stuff used to work but for some reason doesn't
anymore.

I am connecting to a SQL database through ODBC & a linked table.

Jul 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.