I was trying to write the LinqToSQL to call all tabs except ones starting with "Alphabet" (e.g. I don't want a page called "Apple", "Orange", "Strawberry", I want "+34", "(My Page)", "901 Emergency".)

where....first statement
and .....second statement
and... o.TabName.Substring(0,1) < "A"

This did work. HOWEVER, I really don't know why it works.  Could someone explain this? First I thought it's reading ascii value so I created a tab called "{Try This}" because "{" has a bigger ascii value than "A". I mean,,, even B has a bigger ascii value than "A".

[Adding Note:] I put "B" instead of "A", the tab names "Apple" & "ants" were included in the result.

Use Sql Profiler and check what sql is generated by LinQToSql - then you can use SQLBooks Online to find out how the string comparison is working.

Thank you Charles! I'll try that.