Counting spaces with datalength

  • Thanks for your QotD! I answered too quick and didn't think of the difference between Len and DATALENGT().

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • Not my lucky day.

  • Paul White NZ (3/30/2010)


    Not my lucky day.

    That sounds as if you got it wrong. I can't resist asking which error did you make:

    a) 11 is an even number; or

    b) datalength is the same as len

    :hehe:?

    Tom

  • Tom.Thomson (3/31/2010)


    Paul White NZ (3/30/2010)


    Not my lucky day.

    That sounds as if you got it wrong. I can't resist asking which error did you make:

    a) 11 is an even number; or

    b) datalength is the same as len

    :hehe:?

    Neither really - I just looked at it quickly, decided the answer was probably 'one', and went for it.

Viewing 4 posts - 16 through 18 (of 18 total)

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