Post reply

Conversion failed when converting varchar to int

  • March 6, 2015 at 9:38 am

    #305059

    Hi,

    I have a statement that I'm having trouble converting:

    select * from emails join InternalContacts On emails.EmailAddress = InternalContacts.EmailID

    When I run this I get -

    Conversion failed when converting the varchar value 'credentialing@floridaeyeclinic.com' to data type int.

    What is the correct syntax to convert?

  • March 6, 2015 at 9:51 am

    #1782221

    krypto69 (3/6/2015)

    Hi,

    I have a statement that I'm having trouble converting:

    select * from emails join InternalContacts On emails.EmailAddress = InternalContacts.EmailID

    When I run this I get -

    Conversion failed when converting the varchar value 'credentialing@floridaeyeclinic.com' to data type int.

    What is the correct syntax to convert?

    Quick thought, most likely the emails.EmailAddress is a character data type and InternalContacts.EmailID is an integer, try using different columns of the same data type for the join.

    😎

  • March 6, 2015 at 9:57 am

    #1782222

    Thanks wrong column...geez...need some more coffee today

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

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