Answer / mdvasanth86

Anand is right.


SELECT * FROM table_name WHERE column_name LIKE 'C!%'
ESCAPE'!';


If you want to use % or _ as part of your like clause,
you must have an escape character before each occurrence of
% or _ and define what the escape character is like above.

So, an escape character before the % or _ will make it part
of the string rather than a wildcard character(S).


HTH

Answer / bala

Use '%%' to select the data which contains %

Answer / guest

C% will work for all the cases. Even if the data contains
%, Using C% will fetch that too.

Answer / prachi

SELECT NAME FROM EMP WHERE NAME LIKE 'C%';

Answer / anand

hi,
it may be correct ans.check out this..
SELECT * FROM table_name WHERE column_name LIKE 'C%%'
ESCAPE'%';

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

What does db2 stand for?

0 Answers  

What is difference between isnull and coalesce?

0 Answers  

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

What are the isolation levels possible ?

3 Answers  

What is isolation level?

4 Answers  

What is a page?

2 Answers  

What can the Locate option of the Repair Utility accomplish?

2 Answers