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 SkipVought 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
Mar 3, 2003
124
0
0
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
SORT by part of filed 2
Replies
5
Views
69
2009luca
2009luca
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
65
carp
carp
ahadali79
  • Locked
  • Question
Getting a part of string
Replies
2
Views
57
johnherman
johnherman
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
80
szeiss
szeiss
mikrom
  • Locked
  • Question
Functions LOCATE(), POSITION(), POSSTR() 1
Replies
2
Views
34
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top