Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to display data in bold by using select statement Expand / Collapse
Author
Message
Posted Tuesday, May 5, 2009 12:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 17, 2013 12:26 AM
Points: 8, Visits: 52
Hi All,

Is there any way by which the records entered into table will entered as bold

or

while selecting the records it display as bold.

Thanks.
vizay
Post #709927
Posted Tuesday, May 5, 2009 12:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:28 AM
Points: 2,114, Visits: 5,502
The database only handles the data it self. It has nothing to do with the presentation of the data. The application that gets the data should be able to present it in the way that you want (e.g. control the font, size, colure, etc’)

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #709930
Posted Tuesday, May 5, 2009 12:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,229, Visits: 3,483
Hi,

fine

like upper(),lower()

there is any to show in BOLD

ARUN SAS
Post #709932
Posted Tuesday, May 5, 2009 12:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
Records cannot be entered as bold. check the font that is set.

Edit: Iam assuming that you are asking about results being shown in bold in query analyzer.


"Keep Trying"
Post #709938
Posted Tuesday, May 5, 2009 1:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,229, Visits: 3,483
Hi,

declare @ABC table
(
name1 varchar(10)
)
insert into @ABC values ('GOOD')
--for lower
select lower(name1) from @ABC
RESULT
good
--for UPPER
select upper(name1) from @ABC
RESULT
GOOD
--for BOLD
How we make it?

ARUN SAS
Post #709946
Posted Tuesday, May 5, 2009 1:25 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:28 AM
Points: 2,114, Visits: 5,502
There is no way of doing it from the database. You can only do it from presentation tire. Upper() and lower() functions are not controlling the presentation. Those function change the data it self and send different string (e.g. if I run select upper(‘a’) it sends to the client the character A, it doesn’t send it as ‘a’ and tells the application to show it in a different way as ‘A’. You are asking for a function that will control the presentation of the data and there is no such function in the database.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #709951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse