string comparison

  • Thread starter Thread starter Jenny
  • Start date Start date
J

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
 
Define "biggest"...

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

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

....by some other rule?
 
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!
 
Back
Top