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
Explain primary key in sql server?
What happens to a trigger with multiple affected rows?
What is store procedure?
What causes index fragmentation?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is sql server agent and what are the two modes of authentication in sql server?
Explain what are the restrictions while creating batches in sql server?
How many types of database relationship in sql server?
Where do you find the default Index fill factor and how to change it?
What is "scheduled jobs" or "scheduled tasks"?
What do you mean by sql server agent?
What is the name of reporting services config file and what’s it’s used for?
Explain try...catch with sql server?
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.
what changed between the previous version of sql server and the current version? : Sql server database administration