Partial Query

[Cooptoons]

I have a database to keep track of parts we have in inventory. Some of the
part have a dash revision. It would be like 7500-1234-01 or 7500-1234-02. I
would like to be able to query for just the first part of the number, the
7500-1234 and get results. Do you have an example of a script that would do
this?

 

[S.Y.M. Wong-A-Ton]

Search in this newsgroup on "Secondary data source query". You need to modify
the Command on the QueryAdapter to include a WHERE-clause that adds a
wildcard to your query. Example for db in SQL Server:

WHERE <yourpartfieldname> LIKE '7500-1234-%'

or

WHERE <yourpartfieldname> LIKE '7500-1234-__'