Select * From emp Where substr(ename,1,1) In ('a', 'b'

select names starts with a,b,c

Question Posted / roopesh kumar

Answer Posted / roopesh kumar

Select * From emp Where substr(ename,1,1) In
('a', 'b', 'c', 'S');

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

659

State the difference between local and global temporary tables?

796

Explain iaas, paas and saas?

How can we migrate from SQL server to SQL Azure?

106

What is the use of group by clause?

708

Sql server reporting services vs. Crystal reports.

112

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

728

Explain what are partitioned views and distributed partitioned views?

712

How much is a sql server license?

694

How to insert data with null values?

762

Where the sql logs gets stored?

717

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

What are .mdf files?

691

what is a deadlock? : Sql server database administration

682

What are page splits? : SQL Server Architecture

746