Post reply

Convert bigint back to varchar !

  • February 17, 2006 at 3:17 am

    #111662

    During conversion of data a programmer (not me !) accidently read a varchar field into a bigint whilst cursor-ing throgh data and re-exported that as varchar.

    The 'input' field was varchar(15) and contained, say, 000611

    This was read by the stored procedure into a bigint @variable via a cursor resulting in 21319 [can't work out the math of that ! ]

    Question is how can I convert my bigint, which is now in a database table, back into its original varchar string  ?

    Any brilliant mathematicians out there ?

  • February 17, 2006 at 3:50 am

    #621591

    Sorry, Forget this posting; all fixed !!

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

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