Re: [Q] Select Problem

Posted in 1998

Ravi Joseph Pinto — Wed, 08 Apr 1998 12:29:05 -0600 — source: Informix-list mailing list archive (1991-1998)

In article <352B511A.A4893425@quantum.pl>, Pawel Stepniowski <stepniow@quantum.pl> wrote: > > Hi, Hi Pawel, > > anyone know , how to get similar functionality for numerical as LIKE > does for string. > I am developing program which has common frame to select records , > restricted by user input . When user types in 'A*' all records begining > with A will be displayed. > But what if field is not of text type ? How to display records begining > with 5 ? > > please help Try select somecol from sometable where somenumericcol >= input_number > > -- > Pawel Stepniowski > mailto:stepniow@quantum.pl > internet: http://www.quantum.de/~pawel Hope this helps, Ravi.... -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading