Ernst,

>how can I pass the field name in which i want to look up a value to a tsql stored procedure?
>e.G. i want to tell the sp that i want to scan the field custID for a certain value.
>fieldname and value are parameters.

You can create a stored procedure that accepts a character string containing the field name and another parameter that contains the value.

Best Regards,