Member Avatar for rotten69

Hey everyone,

I'm trying to count all Purchases and find ReceiptNo the ones that start with '434'..

Select count(p.purchaseNo) from purchase p (select  INSTR(TO_CHAR(p.recceiptNo), "434") >= 10;

But this line doesn't only select all receipt number starting with 434.. it selects all receipt no that has 434 in it....


I need help with this please

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by hfx642
Member Avatar for hfx642

Simple...

Select Count (*)
From Purchase
Where To_Char (ReceiptNo) Like '434%'
;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.