Subquery with sql % wildcards and where clause

See more:

SQL-Server

how to use %wildcards in where Clause..

I couldnt get exact Result..

i was used this Query

select * from tbl_tree where sponcer_id like '%'(select distinct(sponcer_id) from tbl_tree where advisor_id=29)

the sponcer_id may be like '29,20,25,0'

i wanna get the value where the last value in a column like the sponcerid not exactly this value only the last four value should be like this..

Help..!!!