> 1. 'X' is a string, 0 is a number. The value you use must match Field1's
> datatype.
Field1 is a field I'm defining in the query. It does not exist in the
database.
> 2. In Access, both the "+" and "&" are concatenation operators; they
> differ in that the "+" will *add* values if either operand is numeric.
Fields involved are all text.
> Perhaps ODBC uses only the "+" for concatenation?
Neither "&" or "+" work through ODBC - at least for me.
Thanks.
Chris
------------------------------------
Christopher P. Maher
Maher Associates, Inc.
Actuarial and Computer Consulting
[EMAIL PROTECTED]
http://www.maherassociates.com
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
