User Defined Function in sql server.

Question

Hai Friends,

I am having a table as follows:

ID Row1 Row2

1 a 20

2 b 12

3 c 16

4 a 11

5 a 10

6 c 18

7 b 15

When we pass "a" from "Row1" in a query, we should get the output as follows:

ID          Row1        Row2

1,4,5          a          20,11,10

I should get it by using functions(UDF's).

I have tried a lot friends, but unable to get the solution.

Please any one provide me solution for this.

Thank you.