I want to write a SP in SQL Server, where I would send three parameters and get one result, like so:
1st param a table name 2nd param a field name in that table 3rd param a value I would like to concatenate all three parameters inside the SQL SP to get something like this select (fieldname) from (table name) where (fieldname) = value and I would like to return that value to VFP. IOW, I want to create a stored procedure to be able to check the existence/non existence of a value in a table, to replace the seek command in VFP for instance select account from customers where account = 'RAF1234' if the account exists, I want to receive a positive value and if it does not, a negative one How is this done? please write the stored procedure for me, since I'm new to SQL Server TIA Rafael Copquin _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
