Post reply

How to give a colour to text in sql server column value

  • May 15, 2019 at 10:37 am

    #3642283

    Hi,

     

    I need to make a some text in red colour in sql server column value.

    Below is my column value in DB.

    Read to member: Occasionally we receive notifications from various sources

    In above line I want to make a Read to Member in red and rest should be as it is. How to perform this formatting in sql server.

    I have many rows like  this in table.

     

    Thanks.

  • May 15, 2019 at 10:45 am

    #3642284

    Colorization is a task for a client application.

    Sql server hosts databases with data inside. When you access the data , you use applications (like sqlcmd, management studio, etc).

    If the application supports conditional formatting, then, probably, it's possible to do such "formatting". But I doubt.

     

     

  • May 15, 2019 at 2:33 pm

    #3642396

    Hi,

     

    I have got the way to do it from SQL server.

    REPLACE(ColumnName,'Read to member','Read to member ') as ColumnName

     

    This is making text 'Read to member' in red on UI.

Viewing 3 posts - 1 through 2 (of 2 total)

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