Server-side filter returns SQL error when using "contains" or "starts with" clauses

@formerstaff Thanks.
Can you confirm if lookups can be used as input parameters for stored procedures?

@Elvis_Fernandes
Can you share the work around experience you have with server side scripts to filter data on a database table (not stored procedure)? I am guessing that I have to read the lookup value for the role and pass that into the filter. Any help will be greatly appreciated.

Tunde