Re: [Q] Select Problem

Pawel Stepniowski wrote: > > Hi, > > 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 > > -- > Pawel Stepniowski > mailto:stepniow@quantum.pl > internet: http://www.quantum.de/~pawel I'd question the why you would want to do this. But assuming you do I'd cast the numeric into a char and then test it. This is also assuming you the numerics are not fixed length 'cos then you could use BEWTEEN -- Paul Watson # WF Software Ltd # It said run using Windows 95 Tel: +44 1436 674629 # or better in the manual Fax: +44 1436 678693 # so I used Unix www.wfsoftware.co.uk #