المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Format a float value in sql query



C# Programming
06-29-2009, 12:20 PM
in database the column is like this

EngyVal
10.05
111.9
11.89

after executing my query i want the above values as below

EngyVal
0010.05
0111.90
0011.89


how can i format the column in the select statement