4 Replies Latest reply: Jul 31, 2012 5:40 PM by Marc Livingston RSS

    Adding Rtrim() to indexed fields

      Will applying the function Rtrim() in the select statement cause issues with indexed fields and load time? Our database needs to keep leading spaces and needs to drop trailing spaces. Verbatim pulls in both so I need to apply rtrim() to every field for this to be loaded correctly. Use QVD's so I have to apply this in the incremental load and worried about increased time.