Having trouble concatenating in a where clause

[sk8er1]

I am working with a sp that contains a where clause that is concatenated like so...
Set @wherecmd = ' WHERE ' @addwhere

I need to add a piece of logic to the mix...
AND Matches.Status <> 'x'

I am having trouble with the syntax because of the apostrophes... Can someone help with this....

Thanks

 

[amrita418]

sk8er1,
Since you did not post the original code you are working with, here is an example.

set @v_where = 'where ' + @v_status + ' = ''test'''

Hope this helps,
Regards,
--aa

 

[sk8er1]

This is what i was working with...


declare @wherecmd varchar(50)
Set @wherecmd = 'Where ' + ' matches.status <>' + '''X'''

 

[amrita418]

If you are using the code in dynamic sql then you have two options:
1) Exec('Select * from TableA where ' + @v_fieldname + '<> ''x'''
where @v_fieldname is set to status

2) Set the value of the where clause using

declare @wherecmd varchar(50)
Set @wherecmd = ' Where ' + matches.status + ' <> ''X'''

and use exe sp_executesql (pass the whole query and output parameters as arguments) to get the columns you are looking for.

Regards,
--aa

 

[sk8er1]

Thank you...got it to work.