ERROR when using getDate() in sql to filter data

Question

I am trying to set a condition to a field in sp

If SI0_ADDR.ADDR_EXPR_DATE = '1001-01-01' or > currentDate(), display address active flag = 'Y', else display 'N'.

I am trying this

case [ADDR_EXPR_DATE]
  when '1001-01-01'||[ADDR_EXPR_DATE] > getdate()  then 'Y'
  when  > (getdate()) then 'N'
  else 'N'
end as active_flag

I believe my latest edit to my answer is what you are looking for. — Tab Alleman
– Tab Alleman, Commented Nov 13, 2015 at 21:22

Tab Alleman · Accepted Answer · 2015-11-13 21:21:51Z

3

This: || is not valid in SQL Server.

EDIT:

Ok read your question again and I think this is what you want:

case
      when  [ADDR_EXPR_DATE]='1001-01-01' OR [ADDR_EXPR_DATE] > getdate()  then 'Y'
      else 'N'
    end as active_flag

answered Nov 13, 2015 at 21:16

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

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

2 Comments

Thank You for your help. it got executed with this statement

Please close this question by clicking the checkmark icon to the top left of this answer.