if in partial string of an SQL statement?

Question

I am coding a Table-valued Function in MS SQL 2008 R2.

Is it possible for a partial string of an SQL statement, which is in the WHERE clause to wrap an IF construct?

WHERE MyTable.MyColumn = @MyVariable
      AND (MyColumn2 = @MyVariable2)
ORDER BY MyTable.MyColumn DESC

It's not clear what you are asking. If you add table structure, sample data and expected output it would be a lot easier to see what you want to do. — Mikael Eriksson
– Mikael Eriksson, Commented Nov 27, 2012 at 8:29
I want to pack the "AND (@ MyVariable2 MyColumn2 =)" in an IF construct. And the IF constuct is comparing a value with a defined variable outside of the statement. Do you know now what I mean? — Nikola Stanković
– Nikola Stanković, Commented Nov 27, 2012 at 8:41
Outside I have got a variable @Date and if this variable is not null I would like to expand my Where clause with the partial string "AND (MyColumn2 = @MyVariable2)" — Nikola Stanković
– Nikola Stanković, Commented Nov 27, 2012 at 8:56

podiluska · Accepted Answer · 2012-11-27 09:00:26Z

1

You can use

  WHERE MyTable.MyColumn = @MyVariable
  AND ((@date is null) or (MyColumn2 = @MyVariable2))

answered Nov 27, 2012 at 9:00

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

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

1 Answer 1