string comparison

[Jenny]

Hi,
How do you compare the following valus of a text to see
which value is the biggest?

"20","21", "8B", "C5","W9"

Thanks,
jenny

 

[Ken Snell]

Define "biggest"...

....by the number within the text string?

....by the characters in the text string?

....by some other rule?

 

[Victor Delgadillo]

Simple sorting or comparison of strings will take the ASCII value of the
first character against the same on the other string and continue like that
through the length of the string. In which case, numbers (which have lower
ASCII values than LETTERS) will float up the sorting.

--
Victor Delgadillo MS-MVP Access
Miami, Florida

Mensajes a los grupos de noticia, asi todos nos beneficiamos!