how can use Superscript Or Subscript in sql server

Question

how can use Superscript Or Subscript in sql server stored procedure eg :32 Digree celcious 32 0c

Hemant Srivastava · Answer

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 Choudhary · Answer

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