Formatting as percent

[riluve]

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.

 

[vongrunt]

Multiply by 100, convert to int, convert to varchar, append '%'.

------
Theory: everybody knows everything, nothing works
Practice: everything works, nobody knows why

 

[SQLDenis]

One way
select convert(varchar, convert(int,(field * 100))) + '%' + '%'

declare @v decimal(6,2)
select @v =0.34
select convert(varchar, convert(int,(@v * 100))) + '%'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[riluve]

Dude! that looks like exactly what I need:

convert(varchar, convert(int,(field * 100))) + '%' + '%'

Thnx :-(

But when I put in my query and replace field - I get a syntax error.

:-(

I am using MySQL 3.23.58

The Documentation I find on CONVERT though has a slightly different syntax. I don't find an example of CONVERT used to change data types - only encoding types:

CONVERT(expr USING transcoding_name)

.

 

[riluve]

OH No - lol I am iin the wrong forum - my bad!