Post reply

Difference between two integer format number

  • April 9, 2009 at 7:02 am

    #130465

    Hi all,

    I am just wondering if some one can suggest some way to deal with this problem.

    We have mapping system which draw different dots according to number of postcode it will find in the system. The existing system is having postcode table which is identified by the system. The postcode table is having east and north co ordinator in integer.

    We have one table in our system which is different than table of original system. We have east and north coordinator in SQL table which is integer as well.

    The existing system co ordinator looks like below

    234,123

    231,342

    243,633 etc.

    In our system when we look at the number it looks like 124324, 343532, 353546....it doesnt have , after 3 character....

    now the system dont recognize our table co ordinator.

    What is the difference between this two number - 234,234 & 234234

    Is it something company wrote so that it will recognize or there is any standard difference? Any suggestion>

    thanks,

    Vijay

  • April 9, 2009 at 7:11 am

    #975010

    Thishave , after 3 characterwould indicate a VARCHAR or CHAR datatype. Check the datatypes of the columns in the tables. Try casting to INT or BIGINT the column which has character datatypes.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

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

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