sql server programming: hi. is there a way to pass columns as parameters to a function? (for mssql 2000 server)

my query is something like that:

select tb1.* from tb1
inner join tb2 on tb1.c2=tb2.c1

where tb1.c1 in
(
select * from dbo.fn_Split(tb2.c2,',')
)

error: c2 is not recognized OPTIMIZER LOCK HINTS option

From http://www.developmentnow.com/g/113_0_0_0_0_0/sql-server-programming.htm

Posted via DevelopmentNow.com Groups