Thursday, March 29, 2012

Boolean serach on MS SQL database

Anyone know how to do a bollean search on a database?

It would need to accept 'OR', 'AND' conditions.

Would it be a good idea to maybe create stored procedures and call these somehow?

Thank you in advance.

Michael O'Connorselect * from table where boolfield = 1 or boolfield = 0 and boolfield = 1

heh funny. anyways, what exactly do you mean by boolean search? Can you be more specific?sql

No comments:

Post a Comment