I have one table contains the last field is gender and it is entered in small letter ,i would like to convert to caps after checking the field?
eg:
eno ename loc gender
1 a ch f
2 b hy M
3 c hy m
4 d ch f