trim all

isql -S $SERVER -U $USER -P $PASS -s"|" -b -w999 <<EOF
SET NOCOUNT ON
GO
SELECT
INTERNIDENTITY,
INTERNINSTID,
INTERNVERSION,
INTERNTIMESTAMP,
INTERNRECTYPE,
LTRIM(RTRIM(ORDERID)),
SYNCNUM,
LTRIM(RTRIM(IDSOURCE)),
LTRIM(RTRIM(MEMOID)),
LTRIM(RTRIM(MEMOTYPE)),
BIDPX,
BIDSIZE,
LASTSALE,
LTRIM(RTRIM(MARKETCENTERID)),
LTRIM(RTRIM(MEMOCOMMENTS)),
OFFERPX,
OFFERSIZE,
LTRIM(RTRIM(ORDERIDS)),
ORDSYNCNUM,
LTRIM(RTRIM(CAST(OVERRIDERULESET AS VARCHAR(8000)))),
LTRIM(RTRIM(QUOTECONDITIONINDICATOR)),
QUOTETIME,
LTRIM(RTRIM(RULE92COMMENT)),
LTRIM(RTRIM(SALESTRADERCOMMENTS)),
LTRIM(RTRIM(TICKDIRECTION)),
TOTALDOLVOL,
TOTALVOLUMETRADED,
LTRIM(RTRIM(TRADERCOMMENTS)),
LULDLOWERPXBAND,
LULDUPPERPXBAND,
LULDPXBANDTIMESTAMP
FROM ZMemo
GO
EOF