[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL / BI Publisher

Posted on 2013-12-27
1
Medium Priority
?
138 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 41

Accepted Solution

by:
Sharath earned 2000 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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.

590 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