Post reply

STR

  • October 8, 2013 at 11:04 am

    #1656827

    Mark Cooper-1068662 (10/8/2013)

    I have run this in all versions of SQL Server from 2000 to 2008 R2 and get the same answer - 10 '*'s.

    select STR('8E10') -- returns '**********'

    select len(STR('8E10')) -- returns 10

    Thanks Mark for pointing. Interestingly no one got it. I just checked and agree, it was a typo in description. It's 10 * and not 8 *. 🙂

  • October 8, 2013 at 11:48 am

    #1656842

    Nice - thanks!

  • October 9, 2013 at 7:31 am

    #1657143

    It returns 10 times "*" not 8 times.

Viewing 3 posts - 16 through 17 (of 17 total)

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