trim all2

SELECT
LTRIM(RTRIM(CAST(INTERNIDENTITY AS VARCHAR(20)))) AS INTERNIDENTITY,
LTRIM(RTRIM(CAST(INTERNINSTID AS VARCHAR(20)))) AS INTERNINSTID,
LTRIM(RTRIM(CAST(INTERNVERSION AS VARCHAR(20)))) AS INTERNVERSION,
LTRIM(RTRIM(CAST(INTERNTIMESTAMP AS VARCHAR(30)))) AS INTERNTIMESTAMP,
LTRIM(RTRIM(CAST(INTERNRECTYPE AS VARCHAR(20)))) AS INTERNRECTYPE,
LTRIM(RTRIM(ORDERID)) AS ORDERID,
LTRIM(RTRIM(CAST(SYNCNUM AS VARCHAR(20)))) AS SYNCNUM,
LTRIM(RTRIM(IDSOURCE)) AS IDSOURCE,
LTRIM(RTRIM(MEMOID)) AS MEMOID,
LTRIM(RTRIM(MEMOTYPE)) AS MEMOTYPE,
LTRIM(RTRIM(CAST(BIDPX AS VARCHAR(20)))) AS BIDPX,
LTRIM(RTRIM(CAST(BIDSIZE AS VARCHAR(20)))) AS BIDSIZE,
LTRIM(RTRIM(CAST(LASTSALE AS VARCHAR(20)))) AS LASTSALE,
LTRIM(RTRIM(MARKETCENTERID)) AS MARKETCENTERID,
LTRIM(RTRIM(MEMOCOMMENTS)) AS MEMOCOMMENTS,
LTRIM(RTRIM(CAST(OFFERPX AS VARCHAR(20)))) AS OFFERPX,
LTRIM(RTRIM(CAST(OFFERSIZE AS VARCHAR(20)))) AS OFFERSIZE,
LTRIM(RTRIM(ORDERIDS)) AS ORDERIDS,
LTRIM(RTRIM(CAST(ORDSYNCNUM AS VARCHAR(20)))) AS ORDSYNCNUM,
LTRIM(RTRIM(CAST(OVERRIDERULESET AS VARCHAR(8000)))) AS OVERRIDERULESET,
LTRIM(RTRIM(QUOTECONDITIONINDICATOR)) AS QUOTECONDITIONINDICATOR,
LTRIM(RTRIM(CAST(QUOTETIME AS VARCHAR(20)))) AS QUOTETIME,
LTRIM(RTRIM(RULE92COMMENT)) AS RULE92COMMENT,
LTRIM(RTRIM(SALESTRADERCOMMENTS)) AS SALESTRADERCOMMENTS,
LTRIM(RTRIM(TICKDIRECTION)) AS TICKDIRECTION,
LTRIM(RTRIM(CAST(TOTALDOLVOL AS VARCHAR(20)))) AS TOTALDOLVOL,
LTRIM(RTRIM(CAST(TOTALVOLUMETRADED AS VARCHAR(20)))) AS TOTALVOLUMETRADED,
LTRIM(RTRIM(TRADERCOMMENTS)) AS TRADERCOMMENTS,
LTRIM(RTRIM(CAST(LULDLOWERPXBAND AS VARCHAR(20)))) AS LULDLOWERPXBAND,
LTRIM(RTRIM(CAST(LULDUPPERPXBAND AS VARCHAR(20)))) AS LULDUPPERPXBAND,
LTRIM(RTRIM(CAST(LULDPXBANDTIMESTAMP AS VARCHAR(30)))) AS LULDPXBANDTIMESTAMP
FROM ZMemo;