...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?

__________________

---

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

__________________

---

Yes that is possible.you can use Compute("MAX)

connection.Open();
OleDbCommand mycommand = new OleDbCommand();
mycommand.Connection = connection;
DataTable categories = GetDataTable("categories", "SELECT * FROM categories", connection);
string orders = categories.Compute("MAid_category)", "").ToString();

__________________

---