Thanks Grant

I tried this

WHERE (p.fk_projectId = @pid)

AND lang.langcode =

CASE

WHEN @ulang <> 'al' THEN @ulang

END

AND lc.locstring =

CASE

WHEN @uid = 0 THEN LIKE '%' + @STR + '%'

WHEN @uid = 1 THEN = @STR

END

but its throwing an error near the LIKE

How can I fix that?

Thanks again