Formatting a string in SQL Server

Question

I have a report and it must display text from a table, and I am not allowed to just type the text in the report or this would be really easy.

I just want to bold one word in a SQL string, and have it show up bolded in the SSRS report. Is there a way to format strings in SQL Server?

That type of text formatting should be done on the report side, not from the SQL side. — mellodev
– mellodev, Commented Jul 31, 2012 at 19:12

Yaroslav · Accepted Answer · 2012-07-31 19:13:33Z

4

No, you can not. SQL Server stores and manipulates data, but is not meant to format it, let alone trying to apply some kind of visual formatting.

answered Jul 31, 2012 at 19:13

Yaroslav

6,55210 gold badges54 silver badges91 bronze badges

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

Comments

Oded · Accepted Answer · 2012-07-31 19:12:45Z

0

Strings in SQL Server (or rather, text types, like CHAR, VARCHAR, NCHAR and NVARCHAR) are simply textual - they have no formatting and can't have formatting.

You will need to make the values bold in the report itself.

answered Jul 31, 2012 at 19:12

Oded

501k102 gold badges900 silver badges1k bronze badges

Comments

SQLMason · Accepted Answer · 2012-07-31 19:23:01Z

0

You can't change the font for the strings in SQL Server. Any formatting ~~must~~ should be done in the Report.

edited Jul 31, 2012 at 19:23

SQLMason

3,2851 gold badge32 silver badges40 bronze badges

answered Jul 31, 2012 at 19:11

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Collectives™ on Stack Overflow

Formatting a string in SQL Server

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related