You're probably just missing the single quotes around your search value.

~~Bonnie



>Whats the correct syntax for pulling data from SQL using 'LIKE'?
>
>
>This does not work
>

>
>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'"
>