Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I have table name in that I have
Rajesh
Reshika
Priya
I want the result Like only Starting with R
Rajesh
Reshika

Can someone help me to get these results and How?

Answer Posted / guest

SELECT * FROM TABLE NAME LIKE'R%'
OR U CAN USE SUBSTRING
SUBSTRING(RAJESH,1,1)

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2520


Is it possible to create multiple domains on a single Informatica server?

1243


What is the way to execute pl/sql script using informatica mapping?

1607


What are pre and post-session shell commands?

1312


What is target designer and target load order?

1108


Where can we find the throughput option in informatica?

1064


Define Pmrep command?

1066


Why sorter is an active transformation?

1195


waht type of interface is used for testing the data in informatica

2258


Write the unconnected lookup syntax?

1084


what is informatica metadata?

1038


Under which circumstances, informatica server creates reject files?

1096


What are the components of workflow manager?

1102


How do you load only null records into target? Explain through mapping flow.

2028


Can we change Dynamic to Static or Persistent cache? If so what happens?

2211