danke

What you are doing is generally a sensible approach but you need to view the Actual Execution Plan that Sql Server generates to see if they are being used by the Query Optimizer. There is a free pdf download from Red-Gate[^] that is very good. http://www.simple-talk.com/books/sql-books/sql-server-execution-plans/[^] If you are willing to spend some money, then buy this book. SQL Server 2008 Query Performance Tuning Distilled[^] I can't recommend this book highly enough. Although it is targeted at Sql2008, it's still very applicable to Sql2005 as well.

You're welcome. "When did ignorance become a point of view" - Dilbert

VARCHAR is a variable length string of ASCII characters while NVARCHAR is a variable length string of UNICODE characters.Since NVARCHAR can handle unicode characters, so it allows to use multiple languages in the database. Each ASCII character takes one Byte of space while each UNICODE character takes two Bytes of space. It means NVARCHAR takes twice as much space to store to allow for the extended character set required by some other languages.

That makes sense. Good info, ty.

Mike654321 wrote: 55 is excluded because it has a link of 4 and 5...and 77 is excluded because it has a link of 4 in it. That was useful info. Is it something like this you need? SELECT Table1.field2 FROM Table1 join Table2 ON Table1.field1 = Table2.field1 WHERE Table2.field2 = 9 AND Table1.field2 NOT IN ( SELECT DISTINCT Table1.field2 FROM Table1 join Table2 ON Table1.field1 = Table2.field1 WHERE Table2.field2 <> 9 ) ; This query might be very slow if the tables are big. which can be cured with composite indexes on both tables. My postings are a natural product. The slight variations in spelling and grammar enhance their individual character and beauty and are in no way to be considered flaws or defects.

As long as the proper permissions have been applied to the folder I don't see why it shouldn't work 2) You could use some inline script within the head element <%= InsertMeta() %> protected string InsertMeta() { return @""; } I know the language. I've read a book. - _Madmatt