GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Database  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 45 of 143    Print  
What operator performs pattern matching?

  
Total Answers and Comments: 11 Last Update: June 08, 2009     Asked by: VINNY 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
October 17, 2005 01:11:18   
venkat        

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?
LIKE
 
Is this answer useful? Yes | No
November 03, 2005 05:15:06   
KODANDARAO        

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?
LIKE
 
Is this answer useful? Yes | No
November 07, 2005 05:29:46   
Prathiba        

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?

LIKE


 
Is this answer useful? Yes | No
November 09, 2005 00:50:17   
aparna.rvd Member Since: October 2005   Contribution: 2    

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?
Like Oerator
 
Is this answer useful? Yes | No
December 07, 2005 05:40:36   
CK Raju        

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?
like in instr
 
Is this answer useful? Yes | No
February 15, 2006 10:00:45   
madhu        

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?

pattern matching operator is LIKE and it has to used with two attributes

1. and

2. _ ( underscore )

means matches zero or more characters and under score means mathing exactly one character


 
Is this answer useful? Yes | No
March 11, 2006 01:53:22   
samrat bose        

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?

Like operator.

Where we can use ?.

eg: select ename from emp where ename like 'A ';

It will display all ename starting with 'A'.


 
Is this answer useful? Yes | No
March 11, 2006 04:17:57   
durga4578 Member Since: March 2006   Contribution: 9    

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?
Like operatiorlike ' 'example: suppose u want table name start with character Cselect *from table where tabnam like 'C '
 
Is this answer useful? Yes | No
March 31, 2006 02:18:57   
Dipti        

RE: WHAT OPERATOR PERFORMS PATTERN MATCHING?
LIKE
 
Is this answer useful? Yes | No
February 14, 2007 15:07:50   
srihari        

RE: What operator performs pattern matching?
LIKE operator
 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape