• Is this the same procedure to which you're passing parameters @art_Filter and @sect_Filter as 'P Soni' and 'Ra tata'?

    From the code it looks like @art_Filter and @sect_Filter should be SQL statements...

    For e.g: the SP code has:

    and art_article_type!=5 ' + isnull(@art_Filter,'')

    at this point if you pass in 'Ra tata' this part of the sql string will become:

    and art_article_type!=5 Ra tata

    which doesn't really make too much sense...

    I'd assume that @art_Filter would be some SQL construct like ' AND art_id=100 '