Help SQL Decoding

[fiju]

I am using COLDFUSION . And using coldfusion i am inserting a table using URLEncode function.

For instance, the word 'Registration Fee' will be inserted into a table like 'Registration%20Fee' after encoding using URLEncode function in coldfusion.But I need to write a mssql statement to decode the word and want to return the word like 'Registration Fee' back to the application.

Could any help me to solve this, please

[buddylee17]

See here: http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-urldecode.aspx

You could also create a CLR function utilizing the HttpUtility.UrlDecode Method.

[debasisdas]

Else you can use the REPLACE function for the purpose.