SQL: Check AND/OR string with IF clause

Question

Check '(1=1 AND (1=1 OR 1=1) OR 0=1)' string return true or false

if (1=1 AND (1=1 OR 1=1) OR 0=1)
print '1'
else
print '0'

if i check like this then it returns perfect value but if i have string variable containing value '(1=1 AND (1=1 OR 1=1) OR 0=1)' and then how to check with if clause??

This isn't SQL syntax. It's probably sql-server specific. You should note that. — sheba
– sheba, Commented Nov 7, 2013 at 13:31

Matten · Accepted Answer · 2013-11-07 13:31:28Z

1

You can build up a dynamic query:

declare @conditionString nvarchar(max)
set @conditionString = '(1=1 AND (1=1 OR 1=1) OR 0=1)'

declare @sql nvarchar(max)
set @sql = 'if ' + @conditionString + '
              print ''1''
            else 
              print ''0'''

sp_executeSql @sql

answered Nov 7, 2013 at 13:31

Matten

17.6k2 gold badges45 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL: Check AND/OR string with IF clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related