THE CHARINDEX Code doesn't seem to work. If the varchar has "'John Doe', 'Franl Smith'", it only displays records for the first one, John Doe

I don't want to be able to search with a comma(,)

I want to be able to use an IN function with dynamic varchar values

If someone enters want employees with name...

I have a Transform Data Task which works great. I also have an Execute SQL Task to insert data into the second row. How would I call this SQL Task...

How would I call the stored procedure or Execute SQL task from within the Transform Data Task ActiveX Script. I need the syntax.

The ABS Function did the trick. Thanks Guys!!!