urgent help

[jihan13]

i'll make a comparison between two fields in database(comparison in string) what must I do?

[makai]

strings may be compared directly (alphabetical ordering)

If rs!field1 > rs!field2 Then

if you have some other comparison in mind please specify

[srikandi77]

how can I compare the first string in record 1 with the first string in record 2. Example. record 1 have 011000 and record 2 have 102100. so, how can we compare the first string (0) with the first string in record 2(1).

[Cakkie]

Dim str1 as string, str2 as string
str1 = rst("SomeField")
rst.movenext
str2 = rst("SomeField")




Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook