Get HTML Codes from SQL Server

Question

I have a single quote in a column name, and I want to translate it to ', is there any function to translate a character into a html code? Thank you.

Why do it in SQL? Wouldn't your development framework be a better place? — Bennor McCarthy
– Bennor McCarthy, Commented Dec 6, 2012 at 22:09
is crazy I know, but I would like to retrieve it already from sql and push it into the client — rgx71
– rgx71, Commented Dec 6, 2012 at 22:10
@rgx71 No, there is no native function in SQL server to do this. You will have to write your own user defined function. Here are some native string manipulation methods which may be helpful: msdn.microsoft.com/en-us/library/ms181984(v=sql.105).aspx — Esoteric Screen Name
– Esoteric Screen Name, Commented Dec 6, 2012 at 22:11

Bennor McCarthy · Accepted Answer · 2012-12-07 08:05:19Z

1

You can achieve it with REPLACE, but you'll have to replace every entity manually.

SELECT REPLACE(YourColumn, '''', '&#39;') FROM YourTable

But as I said in the comments, SQL isn't really the right tool for the job.

edited Dec 7, 2012 at 8:05

answered Dec 6, 2012 at 22:10

Bennor McCarthy

11.7k1 gold badge52 silver badges52 bronze badges

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

Comments

Mike Hewitt · Accepted Answer · 2012-12-06 22:12:36Z

1

Try using ASCII ( character_expression )

http://msdn.microsoft.com/en-us/library/ms177545.aspx

answered Dec 6, 2012 at 22:12

Mike Hewitt

7126 silver badges11 bronze badges

Collectives™ on Stack Overflow

Get HTML Codes from SQL Server

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related