Post reply

KNown bugs with Export CSV??????

  • August 11, 2003 at 6:06 am

    #81004

    I have a field that contains the date as a string yyyymmdd format, although the table structure is varchar(8) when the csv runs it converts it back to a numerical column (without "") Is this an issue with their extract?

  • August 11, 2003 at 6:19 am

    #469384

    Hi Namshub,

    quote:

    I have a field that contains the date as a string yyyymmdd format, although the table structure is varchar(8) when the csv runs it converts it back to a numerical column (without "") Is this an issue with their extract?

    I don't think so.

    However, your expression can be evaluated as a number, I guess therefore SQL Server implicitely does so. Use CAST or CONVERT to explicitely make it a varchar

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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