condition

[smilingjohn]

HI ALl

there is a field by name Lead   which has the following content

Lead:

abc_dp

abc_dp1

ABC_dp

ABC_WE

Yzx_r

art

bed

sem

...

i want only those which start from abcor ABC content only

to this iam tying to apply this condition

where Lead:='ABC';    after loading this i dont see any content . can someone try to help me out with this

[smilingjohn]

But i see both the capital and small letter in the lead list box , i want to have all the small abc* to convert to capital ABC*

I tried like this but it did not work

Where WildMatch(Capitalize(Lead),'ABC*');

[smilingjohn]

Hi Mahesh

i tried like this but it did not work

Where WildMatch(Capitalize(Lead),'ABC*');

[Chanty4u]

if you need case sensative search then try with match()

[antoniotiman]

Try

LOAD Upper([Lead:]) as [Lead:]  Inline [
Lead:
abc_dp
abc_dp1
ABC_dp
ABC_WE
Yzx_r
art
bed
sem ]
Where Upper(SubField([Lead:],'_',1))='ABC';

[Chanty4u · Accepted solution]

give a try below

LOAD * INLINE [

    lead

    abc_tp

    abc_dp1

    ABC_dp

    ABC_WE

    YZX_r

    art

    bed

    sem

];

min_temp:

load upper(lead) as lead_ABC Resident main_table where WildMatch( UPPER(lead),'ABC*');