Code: Select all
REL{TUP{ID 1,A "5A053"}, TUP{ID 2, A "64GS6"}, TUP{ID 3, A "YYYY"}, TUP{ID 4, A "X40F"}} WHERE MATCHES(A,"(.*40.*)*(.*GS.*)*")
Code: Select all
RELATION {ID INTEGER, A CHARACTER} {
TUPLE {ID 2, A "64GS6"},
TUPLE {ID 4, A "X40F"}}
Code: Select all
REL{TUP{ID 1,A "5A053"}, TUP{ID 2, A "64GS6"}, TUP{ID 3, A "YYYY"}, TUP{ID 4, A "X40F"}} WHERE SEARCH(TUP{*},"(.*40.*)*(.*GS.*)*")
Code: Select all
RELATION {ID INTEGER, A CHARACTER} {
TUPLE {ID 1, A "5A053"},
TUPLE {ID 2, A "64GS6"},
TUPLE {ID 3, A "YYYY"},
TUPLE {ID 4, A "X40F"}}
Code: Select all
REL{TUP{ID 1,A "5A053"}, TUP{ID 2, A "64GS6"}, TUP{ID 3, A "YYYY"}, TUP{ID 4, A "X40F"}}
WHERE SEARCH(TUP{*},".*40.*") OR SEARCH(TUP{*}, ".*GS.*")