How to display data in bold by using select statement

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » How to display data in bold by using select...

How to display data in bold by using select statement

Rate Topic

Display Mode

Topic Options

Author

Message

k.vizay

Posted Tuesday, May 05, 2009 12:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 5:15 AM
Points: 8, Visits: 51

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

Adi Cohn-120898

Posted Tuesday, May 05, 2009 12:39 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 2,018, Visits: 4,914

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

arun.sas

Posted Tuesday, May 05, 2009 12:44 AM

Ten Centuries

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

Hi,

fine

like upper(),lower()

there is any to show in BOLD

ARUN SAS

Post #709932

ChiragNS

Posted Tuesday, May 05, 2009 12:57 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

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

arun.sas

Posted Tuesday, May 05, 2009 1:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,231, 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

Adi Cohn-120898

Posted Tuesday, May 05, 2009 1:25 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 2,018, Visits: 4,914

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 »

Permissions