Sean Yee wrote: > Hi, > > I have a table of records in which I need to sort by a > specific field. Unfortunately, this field is a String data > type and I wish to cast it to an int. I know that SAP DB > does not support CAST. Is there any work around to this problem?? > > Sean >
Please have a look at http://www.mysql.com/documentation/maxdb/ef/c105b4b9f76e49aeab879ea30cd828/frameset.htm There you will find for example the function NUM which is worth having a second look onto it. BTW: you need to convert it to a number before sorting it? Did you store 1 123 instead of 001 123 or instead of storing what you really seem to need, the numeric value? Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
