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,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com