Formating as Percent

[riluve]

Sorry, I posted this earlier in the wrong forum by mistake

I have a result in a column that comes as a number e.g. 0.1 - I would like to display this number (during a query) in a percent format e.g.

Current Field output:
0.1
1.0
0.34

The preferred output:
10%
100%
34%

Thnx for any guidance.

 

[r937]

select concat('',daColumn*100,'%') as pct
  from daTable

r937.com | rudy.ca

 

[riluve]

koolness thx!