Post reply

Interesting but Stupid Question

  • August 20, 2008 at 12:50 am

    #860421

    "Col1 Like '%Cu_%' " means that matches string with "everything before Cu followed by at least one character"

    '_Cus' = matches because there is substring Cu followed by one character

    'Cus_' = matches because there is substring Cu followed by more than one character

    'C_us' = doesn't match, because there is no substring Cu

    'Cus' = matches because there is substring Cu followed by one charac

    'Cu_s' = matches because there is substring Cu followed by more than one character

    Is it clear?

  • August 20, 2008 at 12:53 am

    #860423

    Thanks..........:):):)

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 2 posts - 16 through 16 (of 16 total)

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