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

select names starts with a,b,c

Answer Posted / senthil

SELECT NAMES FROM TABLE_NAME
WHERE lower(NAME) LIKE 'a%'
or lower(NAME) LIKE 'b%'
or lower(NAME) LIKE 'c%';

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain primary key in sql server?

1072


What happens to a trigger with multiple affected rows?

994


What is store procedure?

1111


What causes index fragmentation?

1045


What is the difference between cube operator and rollup operator? : SQL Server Architecture

1169


What is sql server agent and what are the two modes of authentication in sql server?

1108


Explain what are the restrictions while creating batches in sql server?

1111


How many types of database relationship in sql server?

1100


Where do you find the default Index fill factor and how to change it?

1112


What is "scheduled jobs" or "scheduled tasks"?

1026


What do you mean by sql server agent?

1039


What is the name of reporting services config file and what’s it’s used for?

152


Explain try...catch with sql server?

1071


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2809


what changed between the previous version of sql server and the current version? : Sql server database administration

1052