It really depends on how long the NVARCHAR is, since some of the above (especially those that convert via IntXX) methods will not work:
String s = "005780327584329067506780657065786378061754654532164953264952469215462934562914562194562149516249516294563219437859043758430587066748932647329814687194673219673294677438907385032758065763278963247982360675680570678407806473296472036454612945621946";
Something like that
String s ="0000058757843950000120465875468465874567456745674000004000".TrimStart(new Char[] { '0' } );
Master Stroke Aug 10 '11 at 12:27 2011-08-10 12:27
source share