How to display only specific values from the multiple value column.
Posted on 2012-09-01
I have a Data Table column named code.It can have values like ;1;2;3;4;5;6;7;8;9;..... upto 50
I am trying to get the records only if they have 5,6,7and 8 codes in the column.
But I don't want to display all other values the code column can have.
Ex:I don't want to display like this 2,4,5,8,20,34,45,46.Instead I want to display 5,8.
The column has to show only the values mentioned in the where clause if it has.