how to implement this simple query

See more:

SQL-Server

Dear Friend solve this simple query.

Following is table structure
Table Name: Present
Id IsPresent
1 P
2 P
3 A
4 A

Write query in sql to update all ‘P’ from IsPresent field to ‘A’ and all ‘A’ to ‘P’.
Expected Ans:
Id IsPresent
1 A
2 A
3 P
4 P


Thanks in advanced !