Post reply

Cast /Covert from nvarchar to varchar...during select in oledb src

  • November 5, 2008 at 2:29 pm

    #126792

    Hi all,

    I have my source columns as nvarchar type and want to cast them while select ting to varchar ....how can i do this in se;ect clause itself, i don't want to use a dataconversion after oledb src...

    Any help on this?

    thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • November 5, 2008 at 7:56 pm

    #894632

    If the NVARCHAR column has no multi-lingual entries (the main purpose for NVARCHAR), the a simple SELECT CAST(columnname AS VARCHAR(x)) where x is the desired maximum length should work. Please refer to CONVERT or CAST in Books OnLine for additional information on such conversions.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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