Hi All SQL People,

I need to parse the following SQl statement, to get an out temporary table mentioned below. Can anybody help me out in this please.

/* SQL Statement */

update Organisation set IssueRID = 93, Destination = 'London', HQOfficeID = 10050 where Organisation = 1498

/* Output required as a temp table */

Column Name Value ----------- ------ IssueRID 93 Destination London HQOfficeID 10050

Thanks in advance.

Sushant

-- Sushant (ssaha@pims.co.uk), December 04, 2002