topic Re: Condition for matching 5th ND 6TH RECORD in App Development

Condition for matching 5th ND 6TH RECORD

Aspiring_Developer — Wed, 05 Feb 2020 09:59:03 GMT

Hi ,

I have a below field as :-

FKSTL_PRPS

0000080000

0000000010

CZ010812

CZ019011

I want to get only those ID's whose 5th and 6th records a= *08*

Can anyone please help ?

Re: Condition for matching 5th ND 6TH RECORD

lironbaram — Wed, 05 Feb 2020 10:13:37 GMT

you can use this

FKSTL_PRPS

0000080000

0000000010

CZ010812

CZ019011

where mid(FKSTL_PRPS,5,2) = '08'