I have 2 table table no 1 boxno table no 2 allbox i want like select

See more:

SQL-server-2000

SQL-Server

table one (boxno) have a column name ( EDSboxes ) value like 1234
table tow (allbox) have a column name (IDbox ) value Like CI,1234,DFS,24/11/2011,

i need make select to give me the like value between to column

SELECT *
FROM boxno
WHERE EDSboxes in
(SELECT IDbox FROM allbox where allbox.IDbox Like * boxno.EDSboxes * );

i want typ * on the start and end to give me the same value in the tow table