compare string values in a recordset

[Guest]

Hello everone, I am a newbie and I have a recordset that returns the values

XXXXMain
XXXX1
XXXX2
XXXX3
XXXX4
XXXX5
XXXX6
YYYY1
YYYY2
YYYY3
YYYY4
YYYY5
YYYY6
ZZZZMain
ZZZZ1
ZZZZ2
ZZZZ3
ZZZZ4

but I would like the show the results in a tabular format according to the
first 4 charactes such as XXXX, then YYYY, and finally ZZZZ.

XXXXMain YYYYMain ZZZZMain
XXXX1 YYYY1 ZZZZ1
XXXX2 YYYY2 ZZZZ2
XXXX3 YYYY3 ZZZZ3
XXXX4 YYYY4 ZZZZ4
XXXX5 YYYY5
XXXX6 YYYY6

The select statement is sorting the result set. This result set is
populating a Datatable so I was thinking about somehow while looping through
the result set comparing the first 4 string values and creating a new cell
everytime the string values changes.

Hopefully I explained my intentions clearly.
Thanks In Advance
kw
Thanks in Advance for your assistance.

 

[chanmm]

You can use while loop and if to compare the 1st character. VB.NET should
use Dataset than Recordset.

chanmm

 

[Guest]

Thanks chanmm! Some syntax would be helpful also. I will look into the while
loop in the meantime. I am using C# and using DataSet sorry for the incorrect
usage. But an example would be very helpful!

kw