In a "Set Fields" action, where you wish to read the value for a field from SQL, and you want that value to be obtained from a SQL Server stored procedure, the following code works:
EXEC pr_Remedy_GetExcelPath '$OS$' The stored procedure is called "pr_Remedy_GetExcelPath", and appears as follows: CREATE PROCEDURE pr_Remedy_GetExcelPath @OS varchar(255) AS IF @OS='Windows 2000' SELECT 'C:\Program Files\Microsoft Office\Office\Excel.exe' FROM Control IF @OS='Windows XP' SELECT 'C:\Program Files\Microsoft Office\Office11\Excel.exe' FROM Control Its purpose is to determine the correct path from which to execute Excel depending on the operating system, so the one parameter is a varchar value for OS. Environment: ARS 6.3 SQL Server 2000 Hope this helps, Jim Ashton _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

