Selection

[martijn]

I want to do the following but I don't know how to make a query for it.

SELECT Costumer.Name, Costumer.ID
FROM Costumer
WHERE Costumer.Name ='starts with JAN'
I want to select all the costumers with the name started with JAN, like JANNSSEN, JANSSEN ect.

How can I do that with a query, or mayby Visual Basic Code

 

[SteveA]

The following should do the trick:

SELECT Costumer.Name, Costumer.ID
FROM Costumer
WHERE Costumer.Name Like 'Jan*'

I haven't tested, but it should be OK.

Cheers,
SteveA

 

[martijn]

Thanx,
The code works!

Greetz