select SP2.ID,SP2.Code,SP2.Name,SP2.VATRate,SP2.StoreCard_ID,SP2.StoreUnit_ID,SP2.Supplier_ID from supplierpricelists2 SP2 where SP2.parent_id in (Select ID from supplierpricelists SP where SP.firm_id = :FirmID) and ((Upper(SP2.Code collate PXW_CSY) Like Upper(cast(:Text as varchar(128)))))
Generated by ABRA Software a.s. 27.10.2021 16:34:12