how to swap the value of two colum in the same table

please provide it result as soon as possible

Quote:

Originally Posted by dhanuminu

please provide it result as soon as possible

Hi there,

An idea, with the help of SQL trigger you can swap data between 2 fields.

Please do a little research on SQL trigger for further reading & understanding. Good luck & Take care.