select names starts with a,b,c

Answer Posted / rajkumar v

SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a-c]%'
OR
SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a,b,c]%'

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1098


What are the parts of a function?

523


List some advantages and disadvantages of stored procedure?

571


What is collation sensitivity? Explain different types.

549


Please explain go command in sql server?

598






What is trace flag in sql server?

532


Can you pass expressions to stored procedure parameters?

509


What is the impact on other user sessions when creating indexes?

544


What is 2nf example?

552


What happens if null values are involved in boolean operations?

558


What is a data collection table?

544


How can you hide the sql server instances?

519


What are various ways to enhance the ssrs report?

534


What is sql server database?

500


What is normalization of database? What are its benefits?

518