Pete Phillipps
pete.phillipps at ntlworld.com
Mon Sep 19 18:06:18 CDT 2005
Hello Everyone, I am currently working on learning more about SQL Server 2000 and was wondering what the reason for the N syntax in the first WHERE clause was which was in the script SQL generated. Both statements seem to produce the same results in Query Analyzer. SELECT * FROM sysobjects WHERE name = N'Players' AND type = 'U' SELECT * FROM sysobjects WHERE name = 'Players' AND type = 'U' Thanks for any help. Pete "Many [wargame] battles have been fought and won by soldiers nourished on beer" - Frederick the Great, 1777 Download VIEW FROM THE TRENCHES (Britain's Premier ASL Journal) free from http://www.vftt.co.uk Get the latest news about HEROES(ASL in Blackpool) at http://www.vftt.co.uk/heroesdetails.htm Get the latest news about INTENSIVE FIRE (Britain's biggest ASL tournament) at http://www.vftt.co.uk/ifdetails.htm Support the best at http://www.manutd.com/