Thread: [SOLVED] How to find the maximum value among a list of alpanumeric characters in a da
View Single Post
  #2 (permalink)  
Old 06-10-2007, 05:43 PM
a_non_a_miss_2000
Posts: n/a
When you try to sort or pull a max value from a TEXT field, sorting won't be the same as a numeric field. A text sort will sort by ranking on a per character basis.

So, ser9 will be a "higher" value than ser11 because the function considers "ser9" higher than "ser1xxxxxxxxx....".

The Data Analyst - http://www.squidoo.com/thedataanalyst

__________________
Digg this Post! Del.Icio.Us this Post! Technorati this Post! Furl this Post! Mister Wong this Post! Newsvine this Post! Spurl this Post! Reddit this Post! Netscape this Post!