Pbm with CONTAINS

Hi,
Can i use 'Contains' with a ColumnName like
SELECT * FROM <Table_Name>
WHERE CONTAINS ( <ColumnName>, (SELECT <AnotherColumn> FROM
<anotherTable> ))
regards laraHi
I don't think you can do this, you may want to try something like:
SELECT T.col1
FROM Test1 t, Test2 s
WHERE T.col1 LIKE '%' + s.col1 + '%'
John
"Lara" wrote:

> Hi,
> Can i use 'Contains' with a ColumnName like
> SELECT * FROM <Table_Name>
> WHERE CONTAINS ( <ColumnName>, (SELECT <AnotherColumn> FROM
> <anotherTable> ))
> regards lara
>
>