I have a table:

Name code
text1 2
text2 2
text3 2
text4 3
text5 3

I want to create a cursor gruped by code w/ concatenated Name field:

Cursor1
Name code
Text1, Text2, Text3 2
Text4, Text5 3

but I don't know how:

SELECT ???? AS Name, Code FROM MyTable GROUPED BY MyTable.Code INTO CURSOR Cursor1.


TIA


Boris