SQL / Access 2002 Parameter Query ?

I am converting my data from Access to SQL. I will use Access 2002 Project(adp) application to get to the data.

In access 2000 i was able to combine a Parameter query and wild card when getting data, allowing users to type in part
of a object name and return the data.

It looked like this: like [enter item_id] &"*"

In Access Project (ADP), i am using a In Line Function to query the data.
In the criteria field, i have entered the following: @item_id
It workd fine if the user knows the entire item_id.

Is there a way to add a wildcard at the end, allowing the user to enter part of the item_id?

Or is there a way to get a drop down box in a form used to enter the parameters?

Thank you,
Pfarmer

In the InLine Function try using:

@item_id + '%'

This should give you the same as [item_id] & "*" in Access.

The SQL Query Analyser will let you debug this code and see exactly what is being passed,

Hope this helps - Clive