alter column statement for boolen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a statement that will create a boolean column, using
the alter table command/alter column. What data type is used for boolean
values? Thank you.
 
Jeffrey Howard said:
I am trying to create a statement that will create a boolean column,
using the alter table command/alter column. What data type is used
for boolean values? Thank you.
Click to expand...

In Jet SQL? BOOLEAN, BIT, LOGICAL, YESNO -- any of these should work.
 
Jeffrey said:
I am trying to create a statement that will create a boolean column, using
the alter table command/alter column. What data type is used for boolean
values?
Click to expand...


A97 Help tells me you can use any of these synonyms:
BOOLEAN, BIT, LOGICAL, YESNO
but if one doesn't work, try another.

I generally use YesNo or Boolean.
 
Back
Top