Yes, it´s true, the performing is the same. If you want to know more about old things like the tenebrous jet sql, you have this and about the wildcard characters here. :~

Nothing into access it's better, but the "Jet sql" suggest using like with * as wild pattern. If you use %, the OleDb Provider make the translation for you. If you try

select * from table where field1 like '%something%'

in the query panel of access you get an empty result.

I think he is using an access database, not Sql Server. Better than %, he must use *

Command.CommandText = "SELECT * FROM Users WHERE [User ID] LIKE '*" + txtSearchID.Text + "*'";

but use parameters it´s a good choice.

In access try Command.CommandText = "SELECT * FROM Users WHERE [User ID] = '*" + txtSearchID.Text + "*'";

hendrikbez wrote:

12. After F8 =sqlstring = "select*from tblokkies where luidraad=Hendrik" = myoledbcommand.commandtext = "select*from tblokkies where luidraad=Hendrik"

I think Hendrik must be enclosed with '. SqlStr = "Select * from tblokkies where luidraad = '" & ListBox1.Items(ListBox1.SelectedIndex) & "'" try with select * from tblokkies where luidraad='Hendrik' from Access

First of all, congratulations Mustafa, and even more congratulations to your wife. Second, try to sleep tonight, you will not be able to do it in three months or more. ;)

Could be this? movie : The third man. character : Harry Lime actor : Orson Wells director : Carol Reed. :)Where are my bonus?