Searching text fields from Access database 1

[DickieD]

Help would be appreciated. How do I restrict the data in an SQL query, the field is text and in the criteria box I enter:

Like 'L*'

This works in the Access database but when in VB.NET SQL any field length more than one character does not seem to select the records.

Can anyone help?

 

[icca]

try to replace the wildcard * with %
/icca

 

[DickieD]

Thank you icca, sometimes the books give the wrong information!

Kind regards

 

[KThug]

I also thought you had to use the % twice, ie 'L%%'.

Good Luck
Kennemer