Problem using LIKE and * in ADO command object 1

[Durkin]

I seem to have a problem using LIKE and * in the where clause of an sql statement which I'm using as the commandtext of a command object. It's a statement that's built at runtime so I always use LIKE whether it has any wildcards or not. If the statement uses:

Status LIKE 'U'

then it works fine and I get back the expected records, however if I use:

Status LIKE 'U*'

then I am returned no records.
I am using an Access 2000 database so I went into the query builder and pasted in the sql with the * and it worked fine so it must have to do with the command object rather than Jet. I'm at a loss to explain this strange behaviour so any help would be much appreciated. Durkin
alandurkin@bigpond.com

 

[dpaulson]

Statements using the keyword 'LIKE' will use the wildcard of '%' in ADO
David Paulson

 

[ALSO]

strsql = "status like '" & "*'"

 

[Durkin]

Thanks David. :~/ Durkin
alandurkin@bigpond.com