JWColby
jwcolby at colbyconsulting.com
Tue May 8 10:20:54 CDT 2007
In Access you can do something like: MyAlias: [SomeField] <=10 Which translates into SQL that looks like: [SomeField]<=10 as MyAlias When I try move that (cut and paste) from Access into SQL Server I get a the infamous "syntax error somewhere near <" Question 1: What is wrong with that in SQL Server Question 2: How do I accomplish this directly in the query builder in SQL Server? John W. Colby Colby Consulting www.ColbyConsulting.com