Post reply

RTRIM in DTS package

  • April 9, 2002 at 7:42 am

    #78437

    Hi All,

    When using a query in a dts package, functions parse as valid SQL, however usually the dts package fails. Can someone please tell me how to use functions in a query for a dts package.

    SELECT RTRIM(title), RTRIM(firstname), etc... fails.

    TIA

    Phil Ewington.

  • April 9, 2002 at 8:16 am

    #426863

    OK, all resolved. Seem to always forget this one ;o)

    RTRIM(colname) 'alias'

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply