Important SQL Queries

EID	ENAME	DID	Gender	ELOC
1	Ravi	10	Male	Null
2	Rani	20	Female	Null
3	Naveen	10	Male	Null

 Change the Gender Male to Female or Female to Male in a single query?

UPDATE  emp  set  Gender = CASE  When  Gender=’Male’

Then  ‘Female’

When  Gender=’Female’  Then  Male

End

 Display Ravi details by using the name only without using LIKE operator and JOINS? Without using ‘equals subquery?

SELECT * from Emp Where

ENAME Between ‘Ravi’ AND ‘Ravi’

 Display Names with start V without using LIKE Operator?

SELECT * from Emp WHERE

Charindex(‘V’,ENAME)=1