问一个sql难题

[nameisaj]

SELECT sort_id FROM sort WHERE id in(SELECT TOP 1 treeID FROM sort WHERE id=9)

treeID为字符形，收集了id 如:1,2,3,6

现在有什么办法让以上执行成功？要一句sql语句搞定，难

[newdongkui]

select a.sort_id from sort a , sort b where a.id = b.treeid and b.id = 9

[txlicenhe]

SELECT sort_id FROM sort WHERE treeid in
(SELECT TOP 1 treeID FROM sort WHERE charindex(',9,',','+treeid+',') > 0)

[txlicenhe]

or:
SELECT sort_id FROM sort WHERE treeid in
(SELECT TOP 1 treeID FROM sort WHERE charindex(','+ id +',',','+treeid+',') > 0 and id = 9)

[伍子V5]

SELECT sort_id FROM sort WHERE charindex(cast(id as varchar),(SELECT TOP 1 treeID FROM sort WHERE id=9))>0

[520zyb]

treeID为字符形，收集了id 如:1,2,3,6 这句话让人搞不懂

in后的select语句中只能选一个值
SELECT sort_id FROM sort WHERE id in (SELECT treeID FROM sort WHERE id=9)

[pengdali]

SELECT sort_id FROM sort WHERE charindex(id,(SELECT TOP 1 treeID FROM sort WHERE id=9))>0

[nameisaj]

谢谢各位，我采用了
txlicenhe(马可) 兄弟的方法，谢谢