>Thanks for the information.
>
>Questions. Where do I put that OpenRowSet function? Do I need to create a store procedure or something in SQL?
Forgot this one.
You can pass the previously specified SQL statement as a string to SQL Server to process and it will return everything for you. Or you could, as you say, input it as an SP and make the appropriate call from CF.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao