SQL Server 2000: Column values as arguments to table-valued functions

Short answer - impossible. Apparently the issue has been fixed in 2005.

So basically in sql 2000, you can't do this:

SELECT email
FROM [tb_Email]
WHERE
@job_type IN (SELECT * FROM [dbo].[CsvToIntTable](job_type))

where tb_Email.job_type is a field containing data like '1,2,3,4'
and CsvToIntTable returns this data separated into rows.

The server will return an error like so:
'job_type' is not a recognized OPTIMIZER LOCK HINTS option.

Bugger!