• pollockk (6/30/2008)


    Depends on whether the collation is case-sensitive or not. If it is the answer is 1...

    That's what I thought too, But the Q poser knew that, and knew that I knew that, and I knew that they knew that ... giving an answer alternating between 0 and 1 depending on when you stop.

    *BUT*

    The poser, by not giving an option of "it depends", or "Invalid object name 'TimeGROUP'" gives the game away .. because ..

    ** HERE BE SPOILERS **

    The table is called 'TimeGroup' but the query is 'TimeGROUP'

    If the DB was case-sensitive, then the query would NOT find the table, unless there was ANOTHER table TimeGROUP - and the result of the query was *indeterminate* - not an option - so ...

    The DB must be Case-Insensitive !!

    QED - kind of