Home Forums Article Discussions Article Discussions by Author Discuss content posted by vinaykumar STUFF Function RE: STUFF Function

  • May 17, 2011 at 5:24 am

    #1325686

    Toreador (5/17/2011)

    Koen Verbeeck (5/16/2011)

    And the explanation doesn't mention why inserting NULL in another string doesn't result in NULL, but in an empty space instead.

    That's what got me.

    Surely it's a bug?

    select 'Vinay, ' + NULL + ', Amit'

    returns NULL, so I'd have thought

    select STUFF('Vinay, Vijay, Amit',8,5,NULL)

    should do the same?

    Hi,

    Few days ago, when i was playing with some strings, i found this . That time i also shocked. I feel that we all should know this. that's why i sumbit this question. i think it help us.

    Thx

    Vinay

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!