Professional Web Applications Themes

SQL statement to replace spaces between words with underscore - Microsoft SQL / MS SQL Server

Hi Don See the REPLACE function in Books Online. SELECT REPLACE(LTRIM(RTRIM(name)), SPACE(1), '_' ) FROM Companies John "Don Montgomery" <com> wrote in message news:microsoft.com... ...

  1. #1

    Default Re: SQL statement to replace spaces between words with underscore

    Hi Don

    See the REPLACE function in Books Online.

    SELECT REPLACE(LTRIM(RTRIM(name)), SPACE(1), '_' ) FROM Companies

    John


    "Don Montgomery" <com> wrote in message
    news:microsoft.com... 


    John Guest

  2. #2

    Default Re: SQL statement to replace spaces between words with underscore

    UPDATE Sometable
    SET company_name = REPLACE(company_name,' ','_')

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

    "Don Montgomery" <com> wrote in message
    news:microsoft.com... 


    David Guest

  3. #3

    Default SQL statement to replace spaces between words with underscore

    Is there an SQL statement that will replace spaces between data in a
    text field. The field name is company_name and I need to replace all
    occurances of spaces in the company names with underscores.
    Don Guest

Similar Threads

  1. replace spaces with 0's in a string
    By weezerboy in forum Macromedia ColdFusion
    Replies: 1
    Last Post: February 16th, 09:56 PM
  2. Regular expression - replace non printable chars with spaces
    By Francesco in forum PHP Development
    Replies: 3
    Last Post: December 1st, 05:48 PM
  3. replace words with bold words
    By Lasse Edsvik in forum ASP
    Replies: 9
    Last Post: October 7th, 01:19 PM
  4. How to replace variable spaces with a tab - Please Help
    By Perlwannabe in forum PERL Beginners
    Replies: 2
    Last Post: September 6th, 11:47 PM
  5. Replace words into a string with a space before or after
    By Francesco Moi in forum PERL Miscellaneous
    Replies: 3
    Last Post: August 20th, 01:04 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