Post reply

Length command with trailing spaces?

  • May 20, 2011 at 2:13 pm

    #250509

    How can I get the length of a field including trailing spaces? Trying to see if my data was inputted with spaces afterward, e.g. 'My Data ', was going to just do a select with a LEN but the LEN description says it doesn't count trailing white space, so that would seem to defy the point.

  • May 20, 2011 at 2:17 pm

    #1327968

    Try DATALENGTH('My Data ')

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 20, 2011 at 2:21 pm

    #1327970

    Thanks

  • May 20, 2011 at 2:24 pm

    #1327972

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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