Problems running full-text

Hi.

I have a stored procedure that runs a query using full-text. In my code, I
create a string variable with the full-text expression ans pass this
variable to a paramter in my procedure, in order to avoid dynamic sql in my
stored procedure. My variable is created this way:

strSearchParam = "'""" & strSearch & """'" 'Here I concatenate my search
phrase with double quotes and plics

If I cut and paste the variable contents in my query analyzer, the procedure
runs ok. If I call the procedure from VB.NET passing the variable as a
parameter the procedure returns no rows. Is my concatenation wrong?

Thanks,

Antonio Maciel

Probably. Test it in QA against the stored procedure using the T-SQL
debugger. You may be overdoing the delimiters.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Mon, 30 Jun 2003 10:58:37 -0300, "Antonio Maciel"
<antmac@consys.com> wrote:

>Hi.
>
>I have a stored procedure that runs a query using full-text. In my code, I
>create a string variable with the full-text expression ans pass this
>variable to a paramter in my procedure, in order to avoid dynamic sql in my
>stored procedure. My variable is created this way:
>
>strSearchParam = "'""" & strSearch & """'" 'Here I concatenate my search
>phrase with double quotes and plics
>
>If I cut and paste the variable contents in my query analyzer, the procedure
>runs ok. If I call the procedure from VB.NET passing the variable as a
>parameter the procedure returns no rows. Is my concatenation wrong?
>
>Thanks,
>
>Antonio Maciel
>