Does following solve your problem?
SYSTEM.ADMIN(ADMIN)=> create table testtbl(a1 int, a2 varchar(10));
CREATE TABLE
SYSTEM.ADMIN(ADMIN)=> insert into testtbl values(1, '1234567890');
INSERT 0 1
SYSTEM.ADMIN(ADMIN)=> select to_number(a2, repeat('9', length(a2))) from testtbl;
TO_NUMBER
------------
1234567890
(1 row)
--
Kiran
------------------------------
Kiran Kumar Gahlot
------------------------------
Original Message:
Sent: Thu May 12, 2022 12:42 PM
From: David Briars
Subject: to_number template - Way to Set All '9's'?
In the query below is there a way to specify all nines, without typing in ten nines?
select '1234567890',
to_number('1234567890','9999999999');
------------------------------
David Briars
------------------------------
#NetezzaPerformanceServer