How to display data in bold by using select statement

Question

How to display data in bold by using select statement

k.vizay

Old Hand

Points: 390
More actions
May 5, 2009 at 12:25 am

#131068

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

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/

arun.sas SSChampion Points: 11831 More actions · Answer 2

Hi,

fine

like upper(),lower()

there is any to show in BOLD

ARUN SAS

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

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"

arun.sas SSChampion Points: 11831 More actions · Answer 4

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

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 5

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/