[AccessD] SQL Equivalent

Gustav Brock Gustav at cactus.dk
Tue Mar 3 10:08:07 CST 2009


Hi John

I recall faintly to have struggled with something similar. I think 

Int([FieldA]) = Int([FieldB])

did it. Of course, that only works for numerics.

/gustav


>>> jwcolby at colbyconsulting.com 03-03-2009 16:48 >>>
In Access you can create a query, even in the QBW, where you make a field [FieldA]=[FieldB] as 
AIsEqB and the result is a true / false in a separate AIsEqB field.

I have been trying to do that in SQL Server and it just will not accept the additional field.  More 
precisely, it tries to turn the [FieldA]=[FieldB] into a string '[FieldA]=[FieldB]'.

If I manually edit the SQL to include a where clause looking like that it turns it into an inner join.

Is there a way to create this construct (a new field that evaluates to a true / false) in SQL Server?

-- 
John W. Colby
www.ColbyConsulting.com 





More information about the AccessD mailing list