Re: Str Function

What if I need to do something like: select * from tableA where numeric_column[1,2]="15"without using a cursor. Jos' Miguel. Art S. Kagel wrote: > Jos' Miguel Giraldez R. wrote: > > > > Hi all: > > Would you be kindly to help this newbie to find the informix function, that > > converts numeric columns to character type, equivalent to STR? > > There is no such function since Informix automatically converts between > text and numeric based on the type of the variable you are fetching the > data into. Fetch that integer into a string and voila! it's a string. > > Art S. Kagel