ADO - Select Statement

[hyme]

Using the "asterisk" in the 'Like' statement doesn't seem to work in ADO.
If anyone knows a way around it, let me know, Thanx

DAO - This works
strtype = "C*"
dtaClass.RecordSource = "Select * from TypeDesc where TypeDesc Like '" & strType & "'" & " ORDER BY Index"

ADO - This doesn't
strtype = "C*"
adoSearchRS.Open "Select * from TypeDesc where TypeDesc Like '" & strType & "'" & " ORDER BY Index", db, adOpenStatic, adLockOptimistic

[BruceG]

Try a percent sign (%) instead of the asterisk.