how can use Superscript Or Subscript in sql server stored procedure
eg :32 Digree celcious
320c
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Hemant SrivastavaPosted Dec 12, 2014, 2:05 PM
Try this:
DECLARE @Temp NVARCHAR(50)
SET @Temp = N'32' + NCHAR(0x00B0) + N'C'
-- use @Temp variable in your stored proc
PRINT @Temp
Manish Kumar ChoudharyPosted Dec 3, 2014, 6:24 AM
Hi Najim Mulla,
Go through following links it might help u.
http://sqlblog.com/blogs/john_paul_cook/archive/2011/10/30/superscripts-subscripts-special-characters-and-unicode.aspx