Re: SQL Stored Procedure Error - parameter with "-" character

Are you using Full-Text CONTAINS? It would help to see the CREATE
PROCEDURE statement.
amkate wrote:
Hi Everybody,
I had created a stored procedure wherein i had passed the parameter
contains(tablecolumnname,searchstring)
It is working very fine except
if the search string is carrying "-" character.
Let me explain the problem.
if the parameter is
((contains(col1,'"abcd*" '))) then it will return me the results set
with col1 carrying character abcd.

But if I use the same string
((contains(col1,'"xyz-lmn*" '))) then it wont return me the result
set. instead of this i need to modify this parameter as
((contains(nvarchar7,'xyz-lmn '))) then and then it gives me proper
result set.

Can some body tell me why this is happening? I am not an SQL expert.
Little confused about why stored procedure is behaving differently for
parameter containing "-" character.

.

Relevant Pages

  • Re: How to call a CLE from a CLP
    ... CL CALL command cannot be used to invoke DB2 Stored Procedures. ... Create your stored procedure. ... Create your QM query either using STRQM, ... can only use character variables. ...
    (comp.sys.ibm.as400.misc)
  • String List to Array(Table)
    ... and identifing character code i have read an article by Erland Sommarskog ... character list to my stored procedure, but i'm unsure of the most efficiant ... The ChildKey value extracted frrom the list is a PK on other tables, ...
    (microsoft.public.sqlserver.programming)
  • Re: ADO error
    ... When I was passing parameters to ... the stored procedure parameter character values accepted. ... ,@J_DETBDTE DATETIME ...
    (microsoft.public.fox.programmer.exchange)
  • Re: String List to Array(Table)
    ... >and identifing character code i have read an article by Erland Sommarskog ... >character list to my stored procedure, but i'm unsure of the most efficiant ... >The ChildKey value extracted frrom the list is a PK on other tables, ...
    (microsoft.public.sqlserver.programming)
  • SQL Stored Procedure Error - parameter with "-" character
    ... I had created a stored procedure wherein i had passed the parameter ... if the search string is carrying "-" character. ...
    (microsoft.public.sqlserver)
Loading