SQL query output in custom colors

Question

I have a query like

select
  case
      when foo >  0 then 
         'Bar / ' + N'Бар: ' + ' blah blah'
      else 
         'Text / ' + N'текст' + ' blah blah'
  end as 'Baz'

Is there a way to have 'Бар: ' and 'текст' outputted in a different colour? HTML formatting is not a solution as it needs to output into a non-HTML document

SQL doesn't knows anything about text formating, colors, HTML or anything. Such changes should be done client-side. — Alejandro
– Alejandro, Commented Jul 20, 2018 at 13:19
That what I was afraid of - just needed to get it confirmed :) Thx — Feliks
– Feliks, Commented Jul 20, 2018 at 13:32

The Impaler · Accepted Answer · 2018-07-20 14:32:07Z

0

No, there isn't.

SQL is not about formatting, but about storing and retrieving data efficiently and safely.

Use your front-end (the program that receives the data) to show it (render it) as you see fit.

answered Jul 20, 2018 at 14:32

The Impaler

49.3k10 gold badges50 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Feliks Over a year ago

That what I was afraid of - just needed to get it confirmed :) Thx

Collectives™ on Stack Overflow

SQL query output in custom colors

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related