I have a field in a table called item number, its a nvarchar(15) length field. There are approximately 400,000 records in this table. Unfortunately this number now has to be padded as follows
From 111111111111111 To 11111.111111.1111
I've amended the design of the table to make it nvarchar(17), is there a way to update every record in transact with the format above.
Many thanks for your help
View Complete Post