Post reply

Conversion failed when converting the varchar value to data type int.

  • December 30, 2008 at 7:49 am

    #92913

    I am using SQL Server2005

    SELECT FIELD1+ ' : ' + FIELD2 as CONCATFIELD

    FROM MYFILE

    generates the error Conversion failed when converting the varchar value ' : ' to data type int.

    How can i resolve this ?

  • December 30, 2008 at 8:08 am

    #919058

    At least one of your fielsd is an integer datatype. T-SQL won't do implicit type conversion

  • December 30, 2008 at 8:12 am

    #919062

    That is correct. FIELD1 is an integer field.

    I want to concatenate an integer field and a varcharfield. how do i do this ?

  • December 30, 2008 at 8:13 am

    #919063

    OK i find it myself

    STR(FIELD1) does the job

  • December 30, 2008 at 8:14 am

    #919065

    Look up CAST() and Convert() in BOL - that should give you a start.

    HTH

    Andrew

  • December 30, 2008 at 8:21 am

    #919069

    Thanks !

  • December 30, 2008 at 8:22 am

    #919070

    pvc (12/30/2008)

    OK i find it myself

    STR(FIELD1) does the job

    STR() without any length argument gives you a 10 character result where the string is padded with leading blanks. You probably would want to use CAST() instead to have more control over your result or specify a length argument for STR().

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

Viewing 7 posts - 1 through 6 (of 6 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy