Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 18 to 20 digit phone number in below sub query :
SUB callrequest_f(ColumnDetails, KeyColumn)
ColumnDetails = '
batchjobid as [Batch Job ID]
,deleteflag as [Delete Flag]
,modifiedon_src as [Modified on Source]
,modifiedon_stg as [Modified on Staging]
,modifiedon_wh as [Modified on Warehouse]
,Phone_Number as [Phone number]
;'
KeyColumn = '[Call Request WID]';
END SUB
and i am getting phone number like 45675645+e15 ..
I want complete number .please suggest .
where to add cast function in the above sub queries.
May be check this
Try
Text(Phone_Number) as [Phone number]