urgent

[mohanrajsubrama]

Hi Guys,

              I have a table like this and i dont want Customet No which starts from CU.How can i acheive this .i need help to get this solve .

Customer:

LOAD

     No_ as  [Customer No_],

     Name as [Customer Name],

     [Customer Disc_ Group],

     Channel as ChannelGroup,

     [Customer Type],

     [State Code],

     City as  CustomerCity,

FROM

(qvd)

where Customer_No!='C*';

thanks,

mohan

[Sokkorn]

Hi Mohan,

Try this:

where Not WildMatch(Customer_No,'C*');

Regards,

Sokkorn

[er_mohit]

try like

where Customer_No<>'C*';

[kaushiknsolanki]

Try

Customer:

LOAD

     No_ as  [Customer No_],

     Name as [Customer Name],

     [Customer Disc_ Group],

     Channel as ChannelGroup,

     [Customer Type],

     [State Code],

     City as  CustomerCity,

FROM

(qvd)

     Where not(wildmatch(Customer_No,'CU*'));

Regards,

Kaushik Solanki

[#5 · Accepted solution]

Hi,

Try this:

Customer:

LOAD

     No_ as  [Customer No_],

     Name as [Customer Name],

     [Customer Disc_ Group],

     Channel as ChannelGroup,

     [Customer Type],

     [State Code],

     City as  CustomerCity,

FROM

(qvd)

where left(No_,2)<>'CU';

[mohanrajsubrama]

Thanks for quick response Borja.

Regards,

Mohan.