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
(before the Select) (after the Select)
Need the SSN column at 9 digits and nvarchar. Also, looking for the update statement to make the change.
asked Sep 01, 2012 at 03:36 PM in Default
Casting values such as you've shown into a
answered Sep 03, 2012 at 07:37 AM
Kev Riley ♦♦