Using LIKE with single character wildcard

[RichardF]

Hi,

I am trying to using a single character wildcard operator in my SQL ::

cSQL = "select * from customers where TLA like 'R_S'"
rs.Open cSQL ...

this is fine.

however if i do :
cFilter = "TLA like 'R_S'"
rs.Filter = cFilter

then this does not work.

Any ideas ?

Thanks in advance.

 

[johnwm]

SQL wildcard for single character is underscore '_' so if you are using SQL type syntax use underscore.

Access wildcard for single character is question mark '?' so using Access syntax (like Filter) change _ to ?
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[RichardF]

It still doesnt work .

im using VB6 and ADO 2.6.

heres the code...

' in this example FilterString is "TLA Like 'R?S'"
Public FilterResults(FilterString as string)
rsResults.Filter = FilterString
rsResults.MoveFirst
End Sub

 

[albertaguilar]

You cannot use wildcards in the middle of the criteria string, only at the end or at the beginning and the end.

The following sentence is from the Microsoft ADO 2.6 help file (ado260.chm). you can get this file if you download the Microsoft Data Access Components SDK. You can find it at:

http://www.microsoft.com/data/default.htm

In a LIKE clause, you can use a wildcard at the beginning and end of the pattern (for example, LastName Like '*mit*'), or only at the end of the pattern (for example, LastName Like 'Smit*').

 

[RichardF]

that feature really sucks.!

anyway thanks albert, now i will completely redesign my filter form !!