1

I do want to create a column which should has check marks and cross marks.

Here is the part of my query:

iif(order_details.order_status = 'Y',char(252),char(251)) as [completed?]

After I execute the query in SSMS, I'm getting outputs like this - 'ü', 'û'

But I'm assuming, if change from current font to Wingdings in SSMS I'll getting check and cross marks and every outputs will be changed in SSMS. But I only want to change the column completed? .

Here is my result:

enter image description here

Can any one help me to get check marks and a cross marks?

Improve this question
2
  • Really? Are yes and no that hard to understand in the output? How often are you running and analyzing the output of these queries in SSMS?
    – Aaron Bertrand
    May 19, 2016 at 20:29
  • that made sense for me and now I'm sticking with Y and N. Even though I'll feel better if I get check and cross marks.
    – Marin Mohanadas
    May 19, 2016 at 20:44

1 Answer 1

Reset to default
5

This is not possible: the display settings can not be specified per column.

If you set the font to one which definitely supports relevant Unicode code points, you can use these characters instead of relying on a legacy symbols font, while still having normal characters available.

For example "Arial Unicode MS" supports CHECK MARK (U+2713) and HEAVY BALLOT X (U+2718).

Improve this answer
2
  • for curious, if I want to get check marks from Arial Unicode MS then which font do I want to choose Arial Unicode MS or Arial?
    – Marin Mohanadas
    May 19, 2016 at 17:12
  • Without checking, I would assume that if you want Arial Unicode MS then you should pick Arial Unicode MS. It may be that Arial also has characters for those unicode codeponts, and/or others that would be useful for what you want to display, though the site I've linked to does not list it as such.
    – David Spillett
    May 19, 2016 at 17:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.