"LIKE" function in Webi

system · February 29, 2008, 9:04pm

I would like to simulate SQL’s “like” function in Webi, is it possible?

e.g.,
SELECT EMP_NM FROM EMP WHERE NAME LIKE “%Jo%”

RESULT:

   John
   Joseph
   Joan

theblackbird (BOB member since 2006-05-04)

system · February 29, 2008, 9:33pm

Hi,

Use Matches pattern operator.

Marek Chladny (BOB member since 2003-11-27)

system · March 1, 2008, 1:09am

Thanks very much - that resolved my issue!

theblackbird (BOB member since 2006-05-04)