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...

in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Answer Posted / kalpana

select * from emp where name like '%J%'

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a result set object returned by mssql_query()?

1157


What is the difference function and stored procedure?

1060


What is difference between createstatement and preparedstatement?

1090


What is the security model used in sql server 2005?

1010


What is use of @@ spid in sql server?

1213


What is failover clustering overview?

1090


What is attribute hierarchy? : sql server analysis services, ssas

1020


Explain time data type in sal server 2008?

923


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1750


What is data modification?

976


Explain indexed views and partitioned view with their syntax.

1146


Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075


We need to perform what steps in the following order to work with a cursor?

1218


The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1015


Explain Normalization and DE normalization

1114