Like sql query

[Guest_imported]

Does anyone know how to do an sql query using the like keyword from a VB app?

Ex: sqlSel = "Select ""INVOICE"".""Debtor AC NO"" as acno, ""INVOICE"".""JOB NO"" AS JOB "
sqlSel = sqlSel & ", ""INVOICE"".""QUOTE NO"" AS QTE FROM ""INVOICE"" "
sqlSel = sqlSel & "WHERE ""INVOICE"".""QUOTE NO"" LIKE " & Trim(txtQuoteNum.Text) & "%"

 

[Vancouverite]

When doing your LIKE, you need to embed the value inside single quotes (if it is a string value). So, your final line should be:

sqlSel = sqlSel & "WHERE ""INVOICE"".""QUOTE NO"" LIKE '" & Trim(txtQuoteNum.Text) & "%'"

If you are working with a numeric column, LIKE does not work.