Search code examples
sqlinformaticainformatica-powercenter

List the employees whose name starts with 'S' and ends with 'S'?

I know the SQL LIKE statement.

I want to implement SQL LIKE statement in Informatica.

The goal is list all the employees whose name starts with 'S' and ends with 'S'. 

select ENAME from EMP where ENAME LIKE ('S%') and ENAME LIKE('%S');
Solution

  • It looks like Informatica does not have a LIKE equivalent available. You can use REG_MATCH and insert in a regular expression that will match for starts with S and ends with S. Example Below:

    REG_MATCH(ENAME,'[S^]+\w+[S$]')

    RegExr Link: http://regexr.com/3b17b