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')
What dbms are you using?
Anyways, I'll suggest CASE instead of iif and IN instead of || like this:
SELECT CASE WHEN Field in('000','666') then 'TRUE' else 'FALSE' end as Col1
FROM YourTable
EDIT:
For informatica, there are 1 of two options, Either use OR like this:
IIF(Field='000' or Field='666','TRUE','FALSE')
Or use IN like this:
IIF(Field in('000','666'),'TRUE','FALSE')