select pm_policy_no_0,
'LOOP' as pm_lob,last_name,
first_name,
(CASE
WHEN LENGTH( INCEPTION_DATE ) = 3 THEN
'20000' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 4 THEN
'2000' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 5 THEN
'200' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 6 THEN
'19' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 8 THEN
trim( INCEPTION_DATE )
ELSE
trim( INCEPTION_DATE )
END) AS INCEPTION_DATE,
from tblPol
'LOOP' as pm_lob,last_name,
first_name,
(CASE
WHEN LENGTH( INCEPTION_DATE ) = 3 THEN
'20000' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 4 THEN
'2000' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 5 THEN
'200' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 6 THEN
'19' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 8 THEN
trim( INCEPTION_DATE )
ELSE
trim( INCEPTION_DATE )
END) AS INCEPTION_DATE,
from tblPol
No comments:
Post a Comment