Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

the position of last occurrence

Status
Not open for further replies.
KatherineF

KatherineF

Technical User
Joined
Mar 3, 2003
Messages
124
Location
US
Is there a way to find the position of last character occurrence in the string having count of occurrences
(using no loop)
 
Sort by date Sort by votes
you mean somefunction('x','abxdefxhijxlmno') yielding 11 (position) and 3 (count)?

not in ansi sql, i don't think

what database are you using?


rudy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question Question
SORT by part of filed
Replies
5
Views
772
2009luca
2009luca
Tetol
  • Locked
  • Question Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
573
carp
carp
ahadali79
  • Locked
  • Question Question
Getting a part of string
Replies
2
Views
478
johnherman
johnherman
szeiss
  • Locked
  • Question Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
610
szeiss
szeiss
mikrom
  • Locked
  • Question Question
Functions LOCATE(), POSITION(), POSSTR()
Replies
2
Views
310
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top