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?
Quote from: Virgin on 09 Mar 2015 06:42:18 AM
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
YES it's exactly that
It might depend on your backend database, but something like this might work:
substring([Quotation],datalength(trim([Quotation])),1) not in ('A','B', 'C')
thanks you very much, it's ok
Quote from: Virgin on 09 Mar 2015 06:47:40 AM
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