How to display data in bold by using select statement

  • 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

  • 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/

  • Hi,

    fine

    like upper(),lower()

    there is any to show in BOLD

    ARUN SAS

  • 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"

  • 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

  • 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/

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

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