comparing in database

[puma]

Does somebody know how I can compare two items in a sql database?

code goes like this:

While classgroup.Read
if ??????????????????????????????????
strNew = "net group " & classgroup(1) & " /add"
strAll = strAll & vbCrLf & strNew
end if
End While


I want to compare the value of classgroup compared with the next classgroup,
and if the classgroup isn't the same, put it in the string (strAll)

[TRScheel]

Does somebody know how I can compare two items in a sql database?

code goes like this:

While classgroup.Read
if ??????????????????????????????????
strNew = "net group " & classgroup(1) & " /add"
strAll = strAll & vbCrLf & strNew
end if
End While


I want to compare the value of classgroup compared with the next classgroup,
and if the classgroup isn't the same, put it in the string (strAll)

Create a string outside the while loop to hold the previous string. If the string does not equal the current string, (or strNew), then add the previous string to the strAll

[Frinavale]

Does somebody know how I can compare two items in a sql database?

code goes like this:

While classgroup.Read
if ??????????????????????????????????
strNew = "net group " & classgroup(1) & " /add"
strAll = strAll & vbCrLf & strNew
end if
End While


I want to compare the value of classgroup compared with the next classgroup,
and if the classgroup isn't the same, put it in the string (strAll)

Read from your database.
Grab the first row of data and save it into a variable.
Loop
Grab the next row of data, compare it to the first....
End Loop.

??

[puma]

thanks for the responses,
but the problem is when I save them both to a string
both string would have the same value, it would just compare to the same string

I did this

While classgroup.Read
strprevious = classgroup(1).tostring
strnext = classgroup(1).nextresult.tostring
if strprevious <> strnext then
strNew = "net group " & classgroup(1) & " /add"
strAll = strAll & vbCrLf & strNew
end if
End While

I don't know if I did right with the classgroup(1).nextresult, because it always gives the same value as the strprevious