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

Else you can use the REPLACE function for the purpose.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.