<div>
Edited text of question<br />

</div>


<div>
It works, but it takes away power of CONTAINS <br />
see question Search II too<br />

</div>


It works, but it takes away power of CONTAINS
see question Search II too


<div>
<div class="content wysiwyg-content">
MSSQL 7.0 beta<br />
I full-text- indexed my table and it is fully operational<br />
I need a help with this SP syntax<br />
CREATE &nbsp;PROCEDURE SPsearchGeneraldescription<wbr /><br />
@str char(10)<br />
&nbsp;AS<br />
SELECT Auto, description <br />
FROM [general] &nbsp;<br />
WHERE CONTAINS (description, &nbsp;'@str')<br />
It returns 0 rows, no errors but similar select statement<br />
returns plenty of rows, I tried double quotes too surrounding argument<br />
Without quotes I got syntax error<br />
Any help appreciated<br />

</div>
</div>


MSSQL 7.0 beta
I full-text- indexed my table and it is fully operational
I need a help with this SP syntax
CREATE  PROCEDURE SPsearchGeneraldescription
@str char(10)
 AS
SELECT Auto, description 
FROM [general]  
WHERE CONTAINS (description,  '@str')
It returns 0 rows, no errors but similar select statement
returns plenty of rows, I tried double quotes too surrounding argument
Without quotes I got syntax error
Any help appreciated


search

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.