[thelist] Access JET SQL problem
rudy
r937 at interlog.com
Fri Jan 25 10:09:00 CST 2002
>SELECT [NAME], [MAWB#] FROM [main];
hi jay
> (1) How can I check that "MAWB#" is the actual column name?
this would be one of those very rare times when it's okay to run
select * from main
> (2) How can I select this if it contains the # character,
> and is this what is really causing my problem?
with that special character in the column name, you must always code the
square brackets
rudy
More information about the thelist
mailing list