• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

sql number conversion

UPDATE db_table123
SET [longNumber] = CAST([original_longNumber] as nvarchar(13))

when I copy the original column across I get for example:

153881579694 --> 1.53882e+011
1 Solution
HainKurtSr. System AnalystCommented:
because it is not a long integer, it is float

try casting to bigint first

UPDATE db_table123
SET [longNumber] = CAST(cast([original_longNumber] as bigint) as nvarchar(13))
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now