Hi Every One,

Ii want to use dynamic value in my CONTAIN search:

/*
Create Procedure Usp_search @String1 Varchar(50) , @String2 Varchar(50)
As
Begin
Select LName
From Table_Name
Where
Contains(LName , 'canada and USA' )
End

I want to replace the CANADA and USA with a parameter @String1 and @String2
i created a catalog on table_name

Thank for your help

Alex

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN Premium
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines

MS Sql Server LazyDBA home page