Home » SQL & PL/SQL » SQL & PL/SQL » Query to retrieve a letter
Query to retrieve a letter [message #254477] Thu, 26 July 2007 19:52 Go to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hi

I just want to retrieve a second letter from the word.

For Eg:

Mary----> I want to get the second letter 'a' from the word.

Can anyone please tell me how to write an query for this.

Thanks and Regards,
Prashanth
Re: Query to retrieve a letter [message #254480 is a reply to message #254477] Thu, 26 July 2007 21:00 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
use SUBSTR function
Previous Topic: Question on update table
Next Topic: inane title goes here.
Goto Forum:
  


Current Time: Sat Dec 10 20:25:51 CST 2016

Total time taken to generate the page: 0.08449 seconds