Didn't you try..
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....
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..
Select cast(isnull(column1,'') as varchar(50))+'%',cast(isnull(colum2,'') as varchar(50)+'%',column3.. from table_Name1
here
'%'
is the string value we are adding with the result set from table.
in your case..
select EName,Basic,PF,(cast((PF/Basic*100) as varchar(50))+'%') as [PF Percentage] from Emp where EName='John'
Hope, it'll help you.