Wildcard

[kevbrown]

I need to pull out certain data from a field where the code in that field begins RM, so have the expression, if(UPC='Rm*', 1) but it's not pulling anything out. How do i do a wildcard search for a chart?

Kev

[Kushal_Chawda]

if(wildmatch(UPC,'Rm*'),1) as Flag

or

if( UPC like 'Rm*',1) as Flag

[tamilarasu]

Try this,

If(Wildmatch(UPC,'Rm*'),1)

Or

If(Left(UPC,2)='Rm',1)

[sunny_talwar]

Try this:

If(WildMatch(Upper(UPC), 'RM*'), 1)

or

If(Index(Upper(UPC), 'RM'), 1)

Thanks tamilarasu

[trdandamudi]

May be this:

= if(UPC like 'Rm*', 1)

or

=if(upper(UPC) like 'RM*', 1)