How to peek only numbers from field

[#1]

Hello ,

     I want to peek only numbers from varchar column.

so pls help me in this .

Thank u.

[sushil353]

Please post some sample data

[kumarnatarajan]

Hi,

use Keepchar() function. try below mentioned syntex.

Ex: Keepchar('12ab98q', '0123456789') 

[#4]

try this

LOAD num(test) as number, * INLINE [

    test

    1

    2

    a

    b

    6

    f

];