This content has been marked as final. Show 4 replies
I have a table containing three fields STUDENT, TYPE and MARKS.
I need to split Column TYPE in to two columns i.e.. SUBJECT and EX_TYPE
SUBJECT column will contain PAPER-I, PAPER-II, PAPER-III and so on.
EX_TYPE column will contain INTERNAL, EXTERNAL, PRACTICAL etc.
Can any one help me out of this problem.