sql convert from float to nvarchar
Posted on 2011-03-14
Original SQL Table
want to be able to convert to
some of the numbers start with a '0' (zero) and consequently those entries 1 char less in length that the other db entries for that column.
how do I convert from the float to the nvarchar and add the missing '0''s where applicable ?
when converting (by simply changing in design view within SQL, the number changes to a maths representation, the number is lost .. although a number -- is actually a text field.