sTextVal = txtText.Text.Trim() sSQLCommand = " select " & sSearchField & _ " from " & sSearchAlias & _ " where " & sSearchField & " like " & _ sTextVal & "%"This works fine
sTextVal = txtText.Text.Trim() sSQLCommand = " select " & sSearchField & _ " from " & sSearchAlias & _ " where " & sSearchField & " = 'Electronic'"