get field value using query and convert particular character into uppercase

Question

I want to write query that retrive all employee names. If any employee name contain 'a' character convert into uppercase.

All this i want to do only with query.

for ex.:

Eid Ename

1 ganesh

2 ram

3 sheen

4 aadhar

Should be like: (expected)

Eid Ename

1 gAnesh

2 rAm

3 sheen

4 AAdhAr

Answer 1

Use the replace function

select replace(name, 'a', 'A') from table