I want to convert and display 4.520 to 4520 or 5.000 to 5000 in crystal report and concatenate "zz" at start and end so final string should be zz4520zz or zz5000zz. I am getting number from sql and data is stored in varchar. how can I do this?

enter code here

totext(tonumber({DataTable1.number}),0)

CodePudding user response：

"zz"   totext(tonumber({DataTable1.number}),0,"")   "zz"