SQL Query NOT Between Two Dates

I need some help with SQL Query. I am trying to select all records from table test_table which would not fit between two dates \'2009-12-15\' and \'2010-01-02\'.

Where is the "LEFT" operator in LINQ?

Using SQL Server 2005 I\'ve run a query like this SELECT * FROM mytable WHERE (LEFT (title, 1) BETWEEN @PREFIXFROM AND @PREFIXTO)

sql: BETWEEN v1 AND v2

Is there a difference in the order of v1 and v2 in a BETWEEN query on SQL Server? SELECT * FROM table WHERE col BETWEEN v1 AND v2

between歌词？