The stored proc basically splits the data and returns a dataset with 2 columns...

e.g! Test1~Test2 , 30~40 are the two params passed to the stored proc, while it returns like

Test1...

I have one more scenario;

Table A

Col1 ...

Thanks much for your quick reply.

I'll try using case in Select statement.

Do we have any option where in we can write the expression in some property of the column ?

Thanks...