sql wildcard in VB

[athos07]

hi gud am,

im creating a report using VB, I have a parameter.

sample:

parameter = inputbox ("ENTER LASTNAME.&quot

SQLparam = "SELECT lastname, firstname FROM table1 WHERE lastname LIKE '*"" & parameter & "*'"

ive tried this but there's an error ples help me. thanks.

 

[quisar]

Try using % as wildcard instead of *

Quisar