Update Float to Nvarchar

Question

New to SQL and I have a table with a SSN column that is a float data type and need to change it to nvarchar. Ran the following:

select dbo.ValidSSN(cast(SSN as bigint)), * from temp.__do_metroair

  SSN                                    SSN

(before the Select) (after the Select)

780210101                           780200000000
100110010                           100100000000

Need the SSN column at 9 digits and nvarchar. Also, looking for the update statement to make the change.

Answer 1

0

Casting values such as you've shown into a nvarchar(9) shouldn't be an issue - what is the function dbo.ValidSSN doing - can you post the code?

DECLARE @SSN FLOAT
SET @SSN = 780210101

SELECT @SSN, CAST(CAST(@SSN AS BIGINT) AS NVARCHAR(9))

answered Sep 03 '12 at 07:37 AM

Kev Riley ♦♦
46.1k ● 38 ● 43 ● 69

(comments are locked)