Professional Web Applications Themes

length of string including trailing spaces - Microsoft SQL / MS SQL Server

Hello, Is there a way to find out the length of string including the trailing spaces? LEN excludes the trailing spaces. Thanks!...

  1. #1

    Default length of string including trailing spaces

    Hello,

    Is there a way to find out the length of string including the trailing
    spaces? LEN excludes the trailing spaces.

    Thanks!


    Zeng Guest

  2. #2

    Default Re: length of string including trailing spaces

    If I were isolated and stuck to only my own rookie SQL knowledge, this is
    what I'd wind up doing after reading in the BOL that LEN ignores trailing
    spaces by design:

    SELECT LEN(REPLACE(' whatever ',' ','X'))

    Someone else will probably post and say "Don't use LEN. Use this other
    function that does count trailing spaces," at which point my post will be
    pointless.

    Ray at work


    "Zeng" <com> wrote in message
    news:phx.gbl... 


    Ray Guest

  3. #3

    Default Re: length of string including trailing spaces

    Nice. datalength. Damn.

    Ray at work


    "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
    news:%phx.gbl... 
    >
    >[/ref]


    Ray Guest

  4. #4

    Default Re: length of string including trailing spaces

    thanks!

    "Aaron Bertrand - MVP" <com> wrote in message
    news:#phx.gbl... 
    >
    >[/ref]


    Zeng Guest

Similar Threads

  1. String - Cut off trailing characters
    By Adam Cameron in forum Macromedia ColdFusion
    Replies: 0
    Last Post: February 15th, 11:01 PM
  2. #14013 [Com]: ocibindbyname strips trailing spaces
    By m dot ford at lmu dot ac dot uk in forum PHP Development
    Replies: 2
    Last Post: December 9th, 05:41 PM
  3. Regex searches including spaces
    By Paul Harwood in forum PERL Beginners
    Replies: 2
    Last Post: October 23rd, 02:51 PM
  4. No trailing spaces after closing here doc tag?
    By Chris Morris in forum Ruby
    Replies: 1
    Last Post: August 6th, 02:50 AM
  5. How to get length of string? length() problems
    By Mitchua in forum PERL Modules
    Replies: 5
    Last Post: July 17th, 12:08 AM

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