Code to demonstrate Between Clause inside IIF

Posted by Rajnilari2015 under Sql Server category on 10/27/2016 | Points: 40 | Views : 1558

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

Bookmark It

Posted by: Amatya on: 12/9/2016 Level:Silver | Status: [Member] | Points: 10

How to compare wrt strings?

Latest Code Snipptes