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 / ashok

select * from employee where name like=%'j'%

Thanx
Ashok

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is conditional split?

1087


What is the stored procedure?

1014


What is a cube? : sql server analysis services, ssas

1003


Why is sql server log file full?

1042


What are the recovery models in sql server 2000?

966


how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1633


What do you mean by collation recursive stored procedure?

1059


How to loop through result set objects using mssql_fetch_array()?

1086


Explain what is “asynchronous” communication in sql server service broker?

923


What is a view in sql?

979


How to download and install the scaled-down database adventureworkslt?

992


How would you use user_constraints table in DB?

1008


What happens if you add a new index to large table?

942


Explain about local stored procedure?

976


What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137