Professional Web Applications Themes

Removing Trailing Slash - Microsoft SQL / MS SQL Server

UPDATE sometable SET url_addresss = LEFT(url_addresss,LEN(url_addresss)-1) WHERE RIGHT(url_addresss,1)='/' -- David Portas ------------ Please reply only to the newsgroup -- "Jason Davis" <jasondavis19hotmail.com> wrote in message news:urrMfXhRDHA.2424tk2msftngp13.phx.gbl... > Hi there, > > I have a url_address field (varchar(300)) > Some records has a trailing slash (/) , some not. > > For example: > [url]http://www.cnn.com/[/url] > [url]http://www.cnn.com[/url] > > Is there a way to UPDATE the table to remove the trailing slashes for the > relevent records? > >...

  1. #1

    Default Re: Removing Trailing Slash

    UPDATE sometable
    SET url_addresss = LEFT(url_addresss,LEN(url_addresss)-1)
    WHERE RIGHT(url_addresss,1)='/'

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Jason Davis" <jasondavis19hotmail.com> wrote in message
    news:urrMfXhRDHA.2424tk2msftngp13.phx.gbl...
    > Hi there,
    >
    > I have a url_address field (varchar(300))
    > Some records has a trailing slash (/) , some not.
    >
    > For example:
    > [url]http://www.cnn.com/[/url]
    > [url]http://www.cnn.com[/url]
    >
    > Is there a way to UPDATE the table to remove the trailing slashes for the
    > relevent records?
    >
    >

    David Portas Guest

  2. #2

    Default Re: Removing Trailing Slash

    UPDATE mytable
    SET url_address = LEFT(url_addresss, LEN(url_address) -1)
    WHERE RIGHT(url_address) = '/'

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Jason Davis" <jasondavis19hotmail.com> wrote in message
    news:urrMfXhRDHA.2424tk2msftngp13.phx.gbl...
    > Hi there,
    >
    > I have a url_address field (varchar(300))
    > Some records has a trailing slash (/) , some not.
    >
    > For example:
    > [url]http://www.cnn.com/[/url]
    > [url]http://www.cnn.com[/url]
    >
    > Is there a way to UPDATE the table to remove the trailing slashes for the
    > relevent records?
    >
    >

    Jacco Schalkwijk Guest

  3. #3

    Default Removing Trailing Slash

    Hi there,

    I have a url_address field (varchar(300))
    Some records has a trailing slash (/) , some not.

    For example:
    [url]http://www.cnn.com/[/url]
    [url]http://www.cnn.com[/url]

    Is there a way to UPDATE the table to remove the trailing slashes for the
    relevent records?


    Jason Davis Guest

Similar Threads

  1. #40419 [NEW]: Trailing Slash in CGI request don't work
    By samuele dot diella at gmail dot com in forum PHP Bugs
    Replies: 1
    Last Post: February 13th, 12:24 PM
  2. Replies: 10
    Last Post: January 19th, 06:08 PM
  3. #39298 [Opn->Bgs]: Removing "/" slash works bad
    By tony2001@php.net in forum PHP Bugs
    Replies: 0
    Last Post: October 29th, 02:40 PM
  4. #39298 [NEW]: Removing "/" slash works bad
    By dankeris at gmail dot com in forum PHP Bugs
    Replies: 0
    Last Post: October 29th, 02:37 PM
  5. trailing slash issue in Find.find
    By Jeff Mitchell in forum Ruby
    Replies: 0
    Last Post: August 23rd, 11:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139