Solved

SQL / BI Publisher

Posted on 2013-12-27
1
123 Views
Last Modified: 2014-03-10
Hi,

I have a piece of code used in word / BI Publisher which works
<?if: RESERVATION_TYPE_CODE!='PROV' and contains(RATE_CODE,'STAY')='true'?>

I would like to add an extra condition in so that if

RATE_CODE ='STAY3' or 'Stay 3' the statement is ignored.

Is this possible?
0
Comment
Question by:hellblazeruk
1 Comment
 
LVL 40

Accepted Solution

by:
Sharath earned 500 total points
ID: 39774336
try this.
<?if: RESERVATION_TYPE_CODE!='PROV' and contains(RATE_CODE,'STAY')='true' and RATE_CODE!='STAY3' and RATE_CODE!='Stay 3'?>

Open in new window

0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now