Hello Ralf, a) The CAST AS expression isn't in MaxDB, but there are some functions for data type conversion, but
b) none of these can be applied to a LONG column, and LONG columns cannot be used in expressions for searching, sorting, comparing ... Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Ralf Becker [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 03, 2004 5:26 PM > To: [EMAIL PROTECTED] > Subject: CAST(<column> AS <type) in maxdb? > > > Hi, > > is there an maxdb equivalent to CAST(<column> AS <type>). > > I have eg. a LONG column containing multiple data depending on the > context. In some context they contain just a number, after > which I need > to sort: > > SELECT * FROM <table> SORT BY CAST(<column> AS INTEGER) > > Thanks for any help :-) > > Ralf > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
