[AccessD] SQL Server - Turning comparisons into Booleans

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
 



More information about the AccessD mailing list