STRING (WHERE)

[adiarnon]

HI,

I WANT ALL THE PCA WHERE THEIR PROJECT NOT STARTING WITH "DID"

IS THIS THE RIGHT WAY?

LOAD COMPANY&'-'&LOGISTIC_COMP&'-'&PROJECT&'-'&PCA AS T_Pca,
     COMPANY,
     LOGISTIC_COMP,
     PROJECT,   
     PCA,
     PCA&' - '&PCA_NAME AS PcaNoName
FROM [..\..\DB\QVD\QV_DIM_PCA.qvd] (qvd)
Where PROJECT<>'DID%';

ADI

[tresesco]

Where not Wildmatch(PROJECT ,'DID*' );

[anbu1984 · Accepted solution]

Where Not PROJECT like 'DID*';

Or

Where Not(Left(PROJECT,3) = 'DID' );

[its_anandrjs]

Write like if the text start with word DID then try like

LOAD COMPANY&'-'&LOGISTIC_COMP&'-'&PROJECT&'-'&PCA AS T_Pca,
     COMPANY,
     LOGISTIC_COMP,
     PROJECT,   
     PCA,
     PCA&' - '&PCA_NAME AS PcaNoName
FROM [..\..\DB\QVD\QV_DIM_PCA.qvd] (qvd)
Where Left( PROJECT,3 ) ='DID';

Regards,

Anand

[Anonymous]

Where Left( PROJECT,3 ) <>'DID';

[jagan]

Hi,

Try LIKE with wild card characters

LOAD COMPANY&'-'&LOGISTIC_COMP&'-'&PROJECT&'-'&PCA AS T_Pca,
     COMPANY,
     LOGISTIC_COMP,
     PROJECT,   
     PCA,
     PCA&' - '&PCA_NAME AS PcaNoName
FROM [..\..\DB\QVD\QV_DIM_PCA.qvd] (qvd)
Where PROJECT NOT LIKE 'DID*';

OR

Left(PROJECT, 3) <> 'DID';

Hope this helps you.

Regards,

jagan.

[its_anandrjs]

Hi Adi,

There is lot of write answer suggested if got correct answer then mark Correct or Helpful for references and please close the thread.

Regards

Anand

[tresesco]

If 'LIKE' is to be used, 'Not' should come immediate after WHERE, like:

Where PROJECT NOT LIKE 'DID*';

Where NOT PROJECT LIKE 'DID*';

This is because LIKE is an operator rather than a function.