View Single Post

   
  #7 (permalink)  
Old 02-28-2008, 10:32 AM
Kees Nuyt
 
Posts: n/a
Default Re: SELECT MAX(string) confused by value9 and value10

On Wed, 30 Jan 2008 13:03:22 -0800 (PST),
pieter.thoma@gmail.com wrote:

>Hi,
>
>I can not change my display to see what you mean. When I look to the
>source of your comment you have:
>
>Rack  1
>Rack 10
>
>Does this has to do with what you suggested?
>
>Cheers
>
>Pieter


'Rack' space space '1'
'Rack' space '10'
etc.

or
'Rack001'
'Rack010'
etc.

It's a string, so it sorts like a string.
--
( Kees
)
c[_] Other than telling us how to live, think, marry,
pray, vote, invest, educate our children, and now,
die, I think the Republicans have done a fine job
of getting government out of our personal lives. (#213)
Reply With Quote