Post reply

Hello,exists some set to avoid problems with the comparation between an integer and a varchar??

  • February 21, 2005 at 2:59 pm

    #60233

    Hello friend, i have some problems with my new sqlserver2000 , reciently my company have migrated from sqlserver7 to 2000 and have appears some trouble with the comparation, when i try to comparate a var which is a varchar and another var which is an integer appears an error, so i need to ask to you,

    exists some set quote... or something to avoid the problems with the comparation between varchar and integer?

    a lot of thanks who can help me.......

    PD : sorry my bad english

     

  • February 21, 2005 at 3:15 pm

    #543373

    Use the CAST() or CONVERT() functions to perform data type conversions.

  • February 21, 2005 at 3:22 pm

    #543374

    Thanks but i know that i want some set like the set quoteidentifier on to avoid the problems between  the "" and ' , i need something similar to avoid to use the cast or convert to comparate the varchars and the integers

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

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