I have column history. I need to find out a particuler charcter in a column value, if the value is present then i will pass preior value of the charcter else i need to pass last charcter.
Example: Values are presented like
HIST_ID HISTORY
1 'AAAAAAAAAD'
2 'ABCBHBAAAA'
Search value is 'H'
If 'H' is present in a field i need to pass preior value i.e 'B'. If 'H' is not present in the field i need to pass right most value 'D'.
regards
mandhadi
String search
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom