998 456 22 55 
85 12 32 45
4112321321
455454555 41 555 5554 45

select * from sometable where phone_num containing :param

EXECUTE BLOCK
RETURNS (number VARCHAR(100))
AS
  DECLARE VARIABLE temp VARCHAR(100);
  DECLARE VARIABLE temp_char VARCHAR(1);
  DECLARE VARIABLE step INT;
BEGIN
  FOR SELECT
    sometable.sometext
  FROM sometable
  INTO :temp DO
  BEGIN
    step = 1;
    number = '';
    WHILE (:step < CHAR_LENGTH(:temp)) DO
    BEGIN
      temp_char = SUBSTRING(:temp FROM step FOR 1);
      IF (POSITION(:temp_char IN '0123456789') > 0) THEN
        number = :number || :temp_char;

      step = step + 1;
    END
    SUSPEND;
  END
END

SET TERM ^ ;

create or alter procedure GET_DIGIT_ONLY (
    IPARAM varchar(100))
returns (
    OPARAM varchar(100))
as
declare variable I integer;
begin
  oparam = '';
  i = 1;
  while (i <= char_length(:iparam)) do
  begin
    if (substring(:iparam from i for 1) similar to '[0123456789]')  then
      oparam = :oparam || (substring(:iparam from i for 1));
    i = :i + 1;
  end
  suspend;
end^

SET TERM ; ^

select
  replace(
    replace(
      replace(t.phone, ' ', ''),
    '-', ''),
  '/', '') AS phone
from sometable t