Question on syntax for tdata sql

Database

Question on syntax for tdata sql

Newbie here... What is the syntax to right justify in a fast load? thanks in advance.

CAST(MagTotalPaidAmt as char(10)),

ok... figured it out

CAST((lpad(MagTotalPaidAmt,10)) as char(10)),
1 REPLY
Enthusiast

Re: Question on syntax for tdata sql

Your sharing of the solution is appreciable.