Tag Archives: database

LIKE Query Using Ms. Access And VB.Net

Hi everybody!

This time I want to share my experience about LIKE query on VB.Net using Ms.Access.

I developed an application with VB.Net (3.5 .Net Framework) which use Microsoft Office Access 2003 (mdb) as its database.

And my database provider is Microsoft.Jet.OLEDB.4.0.

The common LIKE query is like this :

SELECT coloumn_name(s) FROM table_name WHERE coloumn_name LIKE ‘%keyword%’

The “%” sign can be used to define wildcards (missing letters in the pattern) both before and after the pattern.

If you run your query on Ms.Access you have to use “*” symbol instead of “%”.

It will go something like this:

SELECT coloumn_name(s) FROM table_name WHERE coloumn_name LIKE ‘*keyword*’

Continue reading

Advertisements