trim3

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