victoriaharry
asked on
splitting values from oracle fields
I have a field in a oracle table which has values in the format
Joe Bloggs - 17/11/2013 10:38:27 AM
Joe Bloggs - 17/10/2014 10:38:27 AM
Joe Bloggs - 17/10/2014 10:50:27 AM
Joe Bloggs - 18/10/2014 10:12:27 AM
Peter Jones - 18/10/2014 09:12:27 AM
Peter Jones - 20/10/2014 09:12:27 AM
What I want to do is a count of all the names in this field which have 2014 in them.
For example, using the values above I would end up with
Joe Bloggs 3
Peter Jones 2
Hope this makes sense and any ideas on how to achieve this would be very appreciated
Thanks
Joe Bloggs - 17/11/2013 10:38:27 AM
Joe Bloggs - 17/10/2014 10:38:27 AM
Joe Bloggs - 17/10/2014 10:50:27 AM
Joe Bloggs - 18/10/2014 10:12:27 AM
Peter Jones - 18/10/2014 09:12:27 AM
Peter Jones - 20/10/2014 09:12:27 AM
What I want to do is a count of all the names in this field which have 2014 in them.
For example, using the values above I would end up with
Joe Bloggs 3
Peter Jones 2
Hope this makes sense and any ideas on how to achieve this would be very appreciated
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Mind if I ask why you selected an answer that doesn't produce the expected results?
Also don't need the rtrim.
Open in new window