SELECT using List of IDs

// ---------- D.Bobkov, June 23, 2003 -----------------
// For example say we have table Stages with StagesID 
// (primary key, int), StageTasksIDs ( text ), etc. 
// and another, linked table, say Tasks with 
// TaskID ( primary key, int), Subject ( varchar(100))
// Field Stages.StageTaskIDs contains comma delimited
// string if IDs from Tasks.TaskID.
// This is the SELECT statement you can use in reports
// to fetch data from Tasks table linked to master table
// Stages:

SELECT TaskID, StagesID FROM Tasks JOIN Stages 
ON CHARINDEX( LTRIM(RTRIM(CAST(TaskID AS varchar(10)))), 
SUBSTRING(StageTaskIDs, 1, DATALENGTH(StageTaskIDs))) > 0