Using LIKE as a comparator in a DTS Lookup Query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Using LIKE as a comparator in a DTS Lookup Query

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-18 : 23:53:26

chris johnson writes "Hello, I recently finished a DTS package that performed a lookup on a Data Transformation Task. I found solution that works well for me, but only after deciding it was impossible to do the lookup that I first attempted. I am new to using lookups in DTS transformation, and the first solution in my case was to use a query like below:

SELECT employee_id
FROM Employees
WHERE firstname LIKE '%?%'

For some reason, this did not work. My final query was something more like this:

SELECT employee_id
FROM Employees
WHERE firstname = ?

I was wondering if it is possible to use the LIKE comparator in a lookup query like I originally tried, or is it not possible?

Thanks,
Chris"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources