Code to demonstrate Between Clause inside IIF

Rajnilari2015
Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 886
declare @a as int =10
declare @b as int =20
declare @c as int =12
select IIF(@c between @a and @b,'Yes it is','No it is not')


Result: Yes it is

Comments or Responses

Posted by: Amatya on: 12/9/2016 Level:Silver | Status: [Member] | Points: 10
How to compare wrt strings?

Login to post response