SELECT query with LIKE doesn't work in a program

[Budsy]

This is a peculiar problem for me. I am finding that the following query works perfectly and gives the expected result set when used in the Access query design environment, but it simply gives no results at all in an otherwise functioning C# web application program:

SELECT * FROM RR_Contacts WHERE FirstName LIKE '*Robert*'

While this query works (gives a result set) with either single or double quotes etc etc using Access to execute the query, but when used within my program, no results of any kind are returned from the same database under the same conditions at the same time (more or less).

I can't see the problem. Am I nuts or missing something simple? Note that all other queries and database functions work as expected. I just can't get the LIKE clause to work in my program. Waaah!

Budsy

[FishVal]

Hi, Budsy.

Try different wildcard.

SELECT * FROM RR_Contacts WHERE FirstName LIKE '%Robert%'
 

[Budsy]

Well I'll be darned! The % wildcard worked. But I thought Access used the asterisk and not the % sign. Ah.... the variable in all this is that maybe the .NET Odbc stuff replaces the % with the * at run time. Or something.

Thanks for the tip!

[FishVal]

Well I'll be darned! The % wildcard worked. But I thought Access used the asterisk and not the % sign. Ah.... the variable in all this is that maybe the .NET Odbc stuff replaces the % with the * at run time. Or something.

Thanks for the tip!

I quite agree with you. That seems to be dataprovider (Jet OLEDB ?) that accepts SQL expressions in ANSI92 standard not native for Access.

Good luck.