Nice Question for Beginners ...

Good One ...

Good Question ... there is always something new to learn

Sorry I was Wrong ...

It is 2,147,483,645 characters

The VARCHAR(MAX) variable in SQL Server 2005 can store string with maximum length of 2,147,483,645 characters

8000 characters

Yes, the Maximum length of the string that can be stored in VARCHAR(MAX) variable in SQL Server 2005 is 8000 characters

Points for taking ...

Good Question ... had to revise all wildcard characters.

I answered 'Operator' - And guess what, I got it wrong. :w00t:

I agree with all the above members, 'IN' is an operator.

Thanks Dave and Dave and for quick replies

Being a greedy person, I hope to get more solutions from forum members to help expand my knowledge horizon.

Does the explanation for the question has any relation with the output of the code? :w00t:

I think this question has nothing to do with your SQL Server Knowledge.

:w 00t: :hehe:

Thanks

This was easy one

Jumble the words to get the correct Question ..

Yes, I get it now. I shall create a proc which will update the SortedCities table.

Thanks Jeff, it was really a great help.

Hi Jeff,

As per your suggestion I made a new...