select names starts with a,b,c
Answers were Sorted based on User's Feedback
Answer / lakshmi narayanan r
SELECT * FROM abc a WHERE a.ename LIKE '[a-c]%'
Is This Answer Correct ? | 19 Yes | 1 No |
Answer / prashant
SELECT NAMES FROM TABLE_NAME
WHERE NAME LIKE 'a%'
or NAME LIKE 'b%'
or NAME LIKE 'c%'
Is This Answer Correct ? | 16 Yes | 6 No |
Answer / naren
Lakshmi Narayanan u r correct.
But we can use the table only.
SELECT * FROM abc WHERE ename LIKE '[a-c]%'
I think its better...
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / 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 |
Answer / 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 |
Answer / gopinath
SELECT NAMES FROM TABLE_NAME
WHERE NAME LIKE 'a%'
or NAME LIKE 'b%'
or NAME LIKE 'c%'
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / roopesh kumar
Select * From emp Where substr(ename,1,1) In
('a', 'b', 'c', 'S');
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / naren
select * from table_name where Name like 'A%'
union
select * from table_name where Name like 'B%'
union
select * from table_name where Name like 'C%'
Is This Answer Correct ? | 6 Yes | 10 No |
your distribution database is full what will u do
what authentication modes does sql server support? : Sql server database administration
What is a trigger and types of a trigger?
What are approximate numeric data types in ms sql server?
How to determine the service pack currently installed on SQL Server?
What is Trigger?
Diff. b/w Full Outer Join And Cross Join?
What is raiseerror? What is raiseerror?
What is MSDE?
What to perform pattern match with the like operator?
How to download microsoft sql server 2005 express edition?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.