Cannot Get SQL Query to Work with "LIKE"
 

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

Cannot Get SQL Query to Work with "LIKE"
 

Try using a % symbol instead of a * symbol

I bleieve * symbol is used with MS Access and % is used with SQL

"Chaplain Doug" wrote:

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

Cannot Get SQL Query to Work with "LIKE"
 

You could try LIKE 'MS%', the like clause in SQL uses % instead of * but I
would have expected ADO to do the conversion for you.

"Chaplain Doug" wrote in message
...
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

Cannot Get SQL Query to Work with "LIKE"
 

Thank you both for the help. God bless.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org


"Terry Aney" wrote:

You could try LIKE 'MS%', the like clause in SQL uses % instead of * but I
would have expected ADO to do the conversion for you.

"Chaplain Doug" wrote in message
...
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