I think your problem is that lcMatch_with is character data in all cases. To make this work try using val(lcMatch_with) for numeric data and similar adaptations for other data types.
>I'm trying to create a find screen, which is having field names in a combo box, a textbox for the user to type value and a list box which gets updated on each pressed key..
>
>For character fields, there is no problem in getting the desired results, but problem comes when user chooses numeric, date, logical or any other data type/field apart from char..
>
>Currently I'm using following sql to get the array for the list box..
>
>Sele distinct &lcFldname from (lcAlias) into array laTmpval ;
>where &lcFldname=lcMatch_with
>
>Pls note that lcmatch_with gets updated on each keystroke and abv sql is called, which gives me a proper result.
>
>can anybody advs. me how to make it generic so that it can support all data types..
>
>Thanks in advance..
>
>p.s. if I use str function to convert numerics in char.. I've to get the correct length and decimal points for each fields..
John Campbell