请教sql语言高手！！！这样一个select 语句怎么写，急！！！！！呀

[checkyvc6]

有一个字段TrainName:其中有T203,k254,678,T226/T227,3756/3757等等还有其对应的id;
如果只给出一个车次名如T203,T226,2757要求查到T203,T226/227,3756/3757对应的TrainId,应该怎么写sql语句呀
如select TrainId From E_Train where TrainName like "%/%";得不到想要的结果
应该怎么写呀？？？？？？
急！！！！！！！

[昵称被占用了]

select TrainId From E_Train where TrainName like "T226/%" or TrainName like "%/226%" or

[checkyvc6]

那个表中还有好多像T226/t227一样的项呢
比如说：T234/T235,T564/T563等等

[pengdali]

select TrainId From E_Train where TrainName like '%226%' and TrainName like '%/%'

[checkyvc6]

绝对不能出现226之类的呀
因为226只不过是我瞎选的一个特例数字呀！！
up!!!
急！！！