Post reply

Modifying the Bit Data Type

  • February 24, 2008 at 4:44 pm

    #184236

    I have a column in a table, that is a bit data type with the values of 1 and 0 (1 for True, 0 for False).

    How would I modify the column so that I could have 3 predetermined codes instead of 2, (100 for approved, 50 for pending, and 0 for not approved)?

  • February 24, 2008 at 5:58 pm

    #781456

    you've got several options for numeric data types:

    tinyint, smallint, int, bigint.

    Look them up in the docs to see what ranges of numbers they hold to make the best decision.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply