Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SuperScript in SQL/SSRS

Answered SuperScript in SQL/SSRS

  • Thursday, February 07, 2013 3:43 PM
     
     
    Sign In to Vote
    0

    Hi ,

    I am facing problem with superscript

    In my table i have data like     "a<sup>2</sup>b<sup>3</sup>"   this should be display as    c²d³, etc

    The values are coming in table variably so i cant do this manually. So please help me on this....I am fine with either SQL or SSRS expressions

    -----------------------------------------------------------------------------------------------------------------

    CREATE TABLE [dbo].[SuperScriptTable](
     [ColumnA] [nvarchar](max) NOT NULL
    ) ON [PRIMARY]
    GO

    INSERT [dbo].[SuperScriptTable] ([ColumnA]) VALUES (N'a<sup>1</sup>b<sup>2</sup>')
    INSERT [dbo].[SuperScriptTable] ([ColumnA]) VALUES (N'c<sup>3</sup>d<sup>4</sup>')
    INSERT [dbo].[SuperScriptTable] ([ColumnA]) VALUES (N'e<sup>5</sup>f<sup>6</sup>')
    INSERT [dbo].[SuperScriptTable] ([ColumnA]) VALUES (N'e<sup>x</sup>f<sup>y</sup>')

    DROP TABLE [dbo].[SuperScriptTable]

    Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com


     

All Replies