monkeymagic2222
Technical User
Hi,
I have an sql database table containing contract information. In it there is a Bit column called "Terminated" which is either True or False. On my aspx page I have a dropdown which has the values Terminated and Current which will send either a true or false value to the database.
I would like to add an extra item to this dropdown to return All (both true and false) values but am unsure how I can do it as its not possible to send a wildcard "%" character to a Bit field.
Thanks in advance.
I have an sql database table containing contract information. In it there is a Bit column called "Terminated" which is either True or False. On my aspx page I have a dropdown which has the values Terminated and Current which will send either a true or false value to the database.
I would like to add an extra item to this dropdown to return All (both true and false) values but am unsure how I can do it as its not possible to send a wildcard "%" character to a Bit field.
Thanks in advance.