You've declared the field as char, so the values are strings and they are compared this way. In 9999 the first position (9) is bigger than the first position of 10000(1), so the result is OK. If you want to compare the numeric values - declare the field as numeric (i.e. Integer). Best regards, Marcin Pytel, Talex S.A. Poznan
Uzytkownik "Andreas Ernst" <[EMAIL PROTECTED]> napisal w wiadomosci [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi to all, > > i have a strange behavior an the system: > > create table masch ( lagnr CHAR( 8), primary key ( LAGNR)) > > insert masch values ('9999') > insert masch values ('10000') > > select max(lagnr) from masch > > I get the result: 9999 > > I expected 10000 > > inserting 200000... > > the same result...... > > OS: > W2K: > SAP DB Kernel 7.3.0 Build 025-000-085-923 > SAP DB JDBC Driver, SAP AG, 7.3.0 Build 029-000-087-559 > and > SuSE Linux 8.0 with the Build 025-xxx .... and the same JDBC-driver > > So i installed on the W2K: > SAP DB Kernel 7.3.0 Build 030-000-088-243 > SAP DB JDBC Driver, SAP AG, 7.4.4 Build 001-000-156-754 > > But i got the same result. > > With this funktion i increase the number of machines, at this moment i > got a problem, that i cannot add machines. > > Any help will be nice!!! > > regards > Andreas _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
