search for a specific string

phanikumar · Post by **phanikumar** » Tue Jan 24, 2012 2:43 am

Hi,

I have a scenario where i need to do a filter records from a particular column where it has value starts with 'zz'.Can some one explain how to acheive this.

Regards

kumar

chulett · Post by **chulett** » Tue Jan 24, 2012 8:09 am

Several ways. What have you tried? One way would be to substring off the first two characters and check them, possibly in a constraint: YourField[1,2] = 'zz'

You could also look into the Filter stage.