Home » Other » Training & Certification » Find Record with Character A(Merged by Arju)
icon1.gif  Find Record with Character A(Merged by Arju) [message #278135] Fri, 02 November 2007 01:04 Go to next message
bangmale
Messages: 2
Registered: November 2007
Junior Member
Hi,
I got a table with a columnname 'NAME'.I want to retrieve the names who got the 'A' as their 11th position in the 'NAME"

Ex;
Kingfisherair
Here the letter 'a' is in 11th position.

Regards,
Bang
Re: Find the record with character A [message #278137 is a reply to message #278135] Fri, 02 November 2007 01:12 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member


Why ot is OPosted in SQL Expert's section ?

Anyway You can try with INSTR Functions ..


Thumbs Up
Rajuvan
Query Required [message #278138 is a reply to message #278135] Fri, 02 November 2007 01:16 Go to previous messageGo to next message
bangmale
Messages: 2
Registered: November 2007
Junior Member
Hi,
I got a table with a columnname 'NAME'.I want to retrieve the names who got the 'A' as their 11th position in the 'NAME"

Ex;
Kingfisherair
Here the letter 'a' is in 11th position.

Regards,
Bang
Re: Query Required [message #278143 is a reply to message #278138] Fri, 02 November 2007 01:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Do you realize the actual homework forum is nearer the bottom of the list than where you posted this?

Can you even spell SQL?
Re: Query Required [message #278144 is a reply to message #278138] Fri, 02 November 2007 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is basic SQL, so post what you already tried.

Regards
Michel
Re: Find the record with character A [message #278150 is a reply to message #278135] Fri, 02 November 2007 01:55 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost.

Regards
Michel


Previous Topic: Explain these terms please
Next Topic: Developer
Goto Forum:
  


Current Time: Fri Mar 29 03:38:55 CDT 2024