SQL syntax

[Christian Dokman]

When I use the LIKE clause in a SQL statement in ASP.NET, it doesn't
seem to work. When I create a query in Microsoft Access and use a Like
clause in the where statement, it works just fine. When I use the same
SQL syntax in ASP.NET, it gives no results. By the way, I use something
like: WHERE (([FieldnameA] = Like ('*Value*')) OR ([FieldnameB] = Like
('*Value*')))
Does anyone know what's the problem here?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Marina]

When using the LIKE keyword, you do not use the = sign. It is just "WHERE
MyField LIKE '%whatever%'"

"Christian Dokman" <de****@developersdex.com> wrote in message
news:Oe**************@TK2MSFTNGP10.phx.gbl...

When I use the LIKE clause in a SQL statement in ASP.NET, it doesn't
seem to work. When I create a query in Microsoft Access and use a Like
clause in the where statement, it works just fine. When I use the same
SQL syntax in ASP.NET, it gives no results. By the way, I use something
like: WHERE (([FieldnameA] = Like ('*Value*')) OR ([FieldnameB] = Like
('*Value*')))
Does anyone know what's the problem here?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Chris Dunaway]

On Tue, 25 Nov 2003 08:36:00 -0500, Marina wrote:

like: WHERE (([FieldnameA] = Like ('*Value*')) OR ([FieldnameB] = Like

Also try using % instead of * (i. e. Like ('%Value%')

--
Chris

To send me an E-mail, remove the underscores and lunchmeat from my E-Mail
address.