Selecting first alphabet from the row
how can i make the select query to get the first alphabet in the string. actually i have a table for voting
messages(msgid(int),message(varchar))
data in the table is as follows
msgid ---- - message
========= -- =======
1 --- v jameel
2 --- vjohn
3 --- /#vjohn
4 --- @Vjameel
5 --- %sjohn
============================
i want to fetch only that rows whos first alphabet is v ommitting anything(special characters,numeric values) before that message
hope that this will clear my question
in my string there may be any special characters also like "%&#V jameel"
so in this case i want to fetch the V.
Thanks in advance
Subject
Views
Written By
Posted
Selecting first alphabet from the row
4028
January 02, 2009 01:14PM
2123
January 02, 2009 09:42PM
2212
January 03, 2009 03:02AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.