Excel 2003. I have a module that grabs some data from an SQL database using
an ADODB connection. If I use the following in the SQL query, it returns no
data:
(WHERE INVOICENUMBER LIKE 'MS*')
However, if I use the following, I get all the data I expect:
(WHERE INVOICENUMBER='MS' AND INVOICENUMBER<='MS9999999999999')
What am I doing wrong? How may I properly use the LIKE phrase? Thanks for
any help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org