Hi Folks,

I have a T-SQL query uses Contains,i have setup the index on my table,My
Question is: How can i pass column value to contains function in T-SQL,My
Query as follows:

SELECT Distinct
      [KW].[displayName]
     ,[KW].[title]
     ,[KW].[mail]
     ,[SG].[mail]
FROM  dbo.Table1 AS KW   Left Outer JOIN
         dbo.Table2 AS SG ON KW.Mail= SG.mail
  Where not contains(KW.proxyAddresses,SG.mail)

The error which i got :  incorrect syntax,the contains function doesnt
recognize the mail column value inb table2.

In the help,you have to pass either a variable or fixed string,i want to
pass a column value which is not mentioned on SQL 2000 or 2k5 help.

waiting for your help.