Dear ALL,
I have a requirement on sql query.
Below is my employee table has record id,each employee short id(group_shortname) ,dept no and full name of each employee group short name.
how can i write this query, when i will pass any one group_shortname, it should search from the comma separated field of group_shortname in the where condition.
select * from employee where group_shortname ='sm12343';
Thanks in advance.