Delete quotation with A,B,C,D...

[Virgin]

Hello everybody,

I have a report with quotation like D15-00001, D15-00002, D15-00002A, D15-00002B...
Quotation with A,B,C... are variant of quotation , for example : D15-00002A is a variant of D15-00002.

I want to delete this variant of quotation, can you help me please?

[Raghuvir]

Hello everybody,

I have a report with quotation like D15-00001, D15-00002, D15-00002A, D15-00002B...
Quotation with A,B,C... are variant of quotation , for example : D15-00002A is a variant of D15-00002.

I want to delete this variant of quotation, can you help me please?

Hi,

does the quotation ends with A,B,C ?

Regards

[Virgin]

YES it's exactly that

[BigChris]

It might depend on your backend database, but something like this might work:

substring([Quotation],datalength(trim([Quotation])),1) not in ('A','B', 'C')

[Virgin]

thanks you very much, it's ok

[Raghuvir]

YES it's exactly that

Hi,

How about using an ends with operator. you can filter out the the quotations that ends with A,B,C.

Regards