This is a very delicate script so I am going to rely on the experts :)
I have an nvarchar field that holds a 11 digit number, all either 1 or 0 values, an example would be: 11001011001
I need to take the first digit and copy that value to a field called 'client_personalprofile' then the second digit to another field and so on. There are two digits I don't need to copy so we can ignore those, below its a table of the digit number from left to right and to which field name it should be copied to.
All fields are in the same table, table name is: "Userlogin"
field1 : client_personalprofile