LIKE only works with exact match in SQL 1

[KisiOne]

I am trying to use wildcards in SQL
here is the vb code
Dim viewSelectQuery As String = "SELECT " & field & " FROM Sales WHERE ProductCode LIKE ""????BLP*"""
here is what the query string looks like when program is run
"SELECT ProductCode, DateSold, TimeSold, QuantitySold, CostPrice, SoldPrice, PaymentMethod FROM Sales WHERE ProductCode LIKE "????BLP*""
nothing is returned
If I replace the "????BLP*" with an exact ProcductCode I get the rows that match that product code. Am I doing something wrong?

 

[chiph]

You came to SQL Sever from MS-Access, right?


The percent-sign (%) is the wildcard character on ANSI-compliant databases.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[KisiOne]

I am populating a VB datagrid from MS access database. No luck with changing to %.

 

[chiph]

Sorry about that - thought you were using SQL Server.
Maybe someone else can help.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[KisiOne]

I beg your pardon - % does work.