Home Forums SQL Server 2005 T-SQL (SS2K5) stored procedure based on conditions RE: stored procedure based on conditions

  • July 2, 2008 at 7:12 am

    #837202

    ok solved it

    someone suggested this on another forum:-

    AND @ulang <> 'al' AND lang.langCode = @ulang

    and ((@uid=0 AND lc.string LIKE '%' + @STR + '%') or (@uid=1 AND lc.string = @STR))