Re: SQL Question???

> > I am trying to do a SQL query on a numeric field. > How do I query the last 2 numbers of a 5 digit field? > Example: number field = 54387 - I want to search for all records that > end in 87. > Thanks I have read somewhere that it will be possible with future releases of INFORMIX to use a MOD function in SQL statements. I can't remember what releases were involved but the correspondence was quite recent. Try using the MOD function on your software! The other question is why is this necessary? If the last two digits of a numeric field are significant in indicating something different to the rest of the numeric field they should be held in a separate column. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc