IIF statement in SQL/ Informatica ( expression transformation) with two values

sql informatica iif
Nidhin_toms picture Nidhin_toms · Feb 3, 2016 · Viewed 26.1k times · Source

I have the following SQL statement which check for the presence of 000. But what if I want to check the presence of either 000 or 666? I tried using | but no luck.....

IIF(Field='000','TRUE','FALSE')

Answer

Vamsi Prabhala picture Vamsi Prabhala · Feb 3, 2016

Use in.

IIF(Field in ('000','666'),'TRUE','FALSE')

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More