Hello
Can anybody help me in this scnerio:
i have a field in my database as student id, which is composition of student_id and department. i want to fetch ids from this. i.e.
student id: 1111*12, details: (1111(student id) *(spliter) 12(departmentid)
i want to have such a query which may pick 1111 from the student id field. length of student id may vary i..e it can be 1 or 11 or 111 etc.
waiting for help.
