You'll need to use dynamic sql somewhat like this.

declare @dt varchar(50), @sql varchar(100)

select @dt = '''11-19-2004'',''12-27-2004'''

select @sql = 'select * from mytable where dtcol in (' + @dt +')'

exec(@sql)

Thanks again for your reply.

The max. no. of records I've in one of the tables is about 80000. I think I'll go ahead with the DTS look up since this is...

Hi Phill

Thanks for the reply. I can't write the kind of T-SQL query you've suggested i.e, joining tables across databases inside DTS.

The max. no. of records I've in one...