Boolean logic parser for SQL

Posted by d03boy on Stack Overflow See other posts from Stack Overflow or by d03boy
Published on 2010-04-09T21:21:40Z Indexed on 2010/04/09 21:23 UTC
Read the original article Hit count: 457

Filed under:
|

This is going to sound crazy but does anyone have techniques that would allow me to parse boolean logic strings in Sql Server 2005 without extraordinary/rediculous effort?

Here is an example: (SOMEVAR=4 OR SOMEVAR=5) AND (NOT OTHERVAR=Y)

I feel like recursion would help a lot if that were possible in Sql but I'm not really sure how to go about that sort of thing. If not, maybe there's a way to attach an external system to do the recursion for me? Don't worry, I'm not getting my hopes up.

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about parsing