Problem with SQL

[elektroman]

Hi guys

I have a problem with a query
I have tried it in access and it goes but in asp it does not give me any result

strSQL="SELECT name_pc FROM ARCH_PC where name_pc like '" & FindIt & "*' "

Thanks in advance

[mmetzger]

What type of database are you querying against? The * character isn't a wildcard in all databases.

[Thread1]

Try to use the "%" instead of "*" in a SQL statement.