Would like to do a Lookup based on a Contains(string) - David Cheng

Hello.  I am migrating a SQL 2000 application that tracks downloaded
online bank transactions.  I have is a reference table for the
transaction type with an index number, i.e. "deposit" = 1,

However, the bank download files do not have consistent transaction
text for each record.  For example, one record might have "Deposit,
branch 123" while another record might have "atm deposit".

Right now, I have a DTS package with an ActiveX script that uses the
InStr function to check for all possible transaction types.  It works
OK, but I have to hard-code my generic transaction text and index
values into the ActiveX script.

What I would like to do a Lookup transformation in combination with
Contains, so that if the download text field contains "deposit", then
I can look up that against the reference table and get the index
number 1.  (That way, I can allow the end-user to update the reference
table in case the bank adds or changes their transaction
descriptions.)

Is this possible?

Thanks
David