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: 25219
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: Mon Feb 20 04:56:56 CST 2017

Total time taken to generate the page: 0.09074 seconds