Re: Informix SQL query on INTEGER column

In article <1993Jul29.203531.7451@porthos.cc.bellcore.com> ggeorge@polo.NoSubdomain.NoDomain (Greg George) writes: } I'm trying to do an informix SQL SELECT on an INTEGER column to get } only the first 3 digits of the number. For example, if i have } the following table: } } CREATE TABLE t1 } ( field1 INTEGER, } field2 CHAR(10) ); } } Now, if I have 12345 in field1, how can I do a select on the table } and only display the first 3 digits (ie: 123). } Have you tried dividing the field by 100 before displaying it? DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.15 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com