Post reply

Is there a URL Decode function?

  • December 18, 2006 at 10:21 am

    #193451

    I am writing a few reports with PHP and the language has a urldecode() function. But, my employer wants the function in SQL. Anyone, help.

  • December 18, 2006 at 11:50 am

    #678758

    take a look at this thread from a couple of years ago...someone adapted the hex scripts to do this:

    I see that that takes care of %20 kind of stuff for an URL... or were you looking for htmlEncode/Decode for code that changes & to & and vice versa?

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=113594

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 19, 2006 at 7:47 am

    #678913

    Yep. Content in that thread is what I need. Thanks.

    (Hey, great signature)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply