If this fails, please try one more time of hardcoding it with the following statement:
"SELECT * FROM Addresses WHERE Zip LIKE '91%'"And let me know if that returns anything as well.
SheSaidImaPregy
28
Veteran Poster
TobbeK
0
Junior Poster
Hi guys
I did some googling and tried to find out things about wildcards.
It might work (just might) if changing this wildcard (%) to this wildcard (*). Depends on what database in use. Some "sources" says that this one is for Access and the (%) is SQL servers. I don't now for sure but it is worth trying if the last hint doesn't work.
' " & izip & " * ' "
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.