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

What is a matrix in ssrs?

101


Are all views updatable ?

728


What are different types of views?

557


What does it mean to normalize a database and why would you do it?

532


Do you have any idea about the tcl commands?

556






What is clustered primary key?

554


What is self contained multi valued query?

560


What is the default value of an integer data type in sql server 2005?

588


What does ss stand for sexually?

592


Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

546


What are sql server functions?

520


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

555


What is service broker?

589


What is partitioned view?

527


Define outer join in sql server joins?

533