Use the IN operator and pass the integer ids as a comma separated string. Build the entire SQL statement in your application and execute the statement itself instead of calling a stored procedure. SELECT * FROM Table WHERE ID IN (param1,param2,...) Hope this helps... Regards, Orina DCosta http://orina.org

Strings in SQL must be enclosed in single quotes. cust_name_search = "'" + txt_custname_search.Text + "%'"; dataview_cust_search.RowFilter = "cust_name LIKE " + cust_name_search; Also, Wildcard characters, * and %, are supported and are used with the LIKE operator. Wildcards are allowed only at the beginning and/or end of a filter string. Regards, Orina http://orina.org