Thread: [SOLVED] How to find the maximum value among a list of alpanumeric characters in a da
View Single Post
  #1 (permalink)  
Old 06-10-2007, 05:42 PM
meena
Posts: n/a
[SOLVED] How to find the maximum value among a list of alpanumeric characters in a da
...in asp.net query? I have a database column "AssetID" with values like ser1.... ser9, ser10, ser11, met1, met2.etc I want an sql query which would retrieve me the highest value among the category "ser" i.e. it should get me the value ser11. If I use max(AssetID) in the query, I get only ser9 and not ser11. So how this is possible?

__________________
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!