Display % symbol to result set of sql query in sql server

Question

0.00/5 (No votes)

See more:

SQL

select EName,Basic,PF,PF/Basic*100 as [PF Percentage] from Emp where EName='John'

Result :

EName    Basic   PF      PF Percentage
John     1000    100         10

But I want to display

PF Percentage
   10 %

Can i write

SQL

select EName,Basic,PF,PF/Basic*100+'%' as [PF Percentage] from Emp where EName='John'

Thanks

Posted 9-Dec-14 18:07pm

Member 9409254

Updated 9-Dec-14 18:15pm

PIEBALDconsult

v3

Add a Solution

Comments

PIEBALDconsult 10-Dec-14 0:17am

You would have to cast it to character first, but that's really a task for the reporting system.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mudgilsks · Answer 1 · 2014-12-09T21:54:00

Solution 4

hi ,

try this

SQL

Select EName,Basic,PF,CAST(PF/Basic*100 as varchar(20)) + '%' as [PF Percentage] from Emp where EName='John'

Posted 9-Dec-14 21:54pm

mudgilsks

Updated 9-Dec-14 22:24pm

v2

_Maxxx_ · Answer 2 · 2014-12-09T18:32:00

Solution 1

select convert(varchar(10), PF/basic * 100) + '%' as [PF Percentage] from applicationInfo

Posted 9-Dec-14 18:32pm

_Maxxx_

Rajesh waran · Answer 3 · 2014-12-09T18:32:00

Solution 2

Before that you have to cast your column to character,try like this
you can set varchar limt as per your needs,

SQL

select EName,Basic,PF,cast(PF/Basic*100 as varchar(50))+'%' as PF_Percentage from Emp where EName='John'

Posted 9-Dec-14 18:32pm

Rajesh waran

Updated 9-Dec-14 22:13pm

v2

Comments

/\jmot 10-Dec-14 3:17am

varchar??? varchar(length)??

Rajesh waran 10-Dec-14 4:15am

Thanks for intimating me,forgot to set limit. Now i updated my solution

/\jmot · Answer 4 · 2014-12-09T21:10:00

Didn't you try..

SQL

select '%'

here we are getting a string '%', and we know that we can con-cat any string to String result set in sql.

We know Simple Query....

SQL

Select column1,colum2,column3.. from table_Name1

If we want to Add any String to the Result set, what we do..??
i think. like this..

SQL

Select cast(isnull(column1,'') as varchar(50))+'%',cast(isnull(colum2,'') as varchar(50)+'%',column3.. from table_Name1

here

SQL

'%'

is the string value we are adding with the result set from table.

in your case..

SQL

select EName,Basic,PF,(cast((PF/Basic*100) as varchar(50))+'%') as [PF Percentage] from Emp where EName='John'

Hope, it'll help you.