venkat

• Oct 17th, 2005

 

LIKE

KODANDARAO

• Nov 3rd, 2005

 

LIKE

Prathiba

• Nov 7th, 2005

 

LIKE

aparna.rvd

 Profile Answers by aparna.rvd 

• Nov 9th, 2005

 

Like Oerator

CK Raju

• Dec 7th, 2005

 

like %,in,instr

madhu

• Feb 15th, 2006

 

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

samrat bose

• Mar 11th, 2006

 

Like operator.

Where we can use %,?.

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

It will display all ename starting with 'A'.

durga4578

 Profile Answers by durga4578 Questions by durga4578

• Mar 11th, 2006

 

Like operatiorlike '%'example: suppose u want table name start with character Cselect *from table where tabnam like 'C%'

Dipti

• Mar 31st, 2006

 

LIKE

srihari

• Feb 14th, 2007

 

LIKE operator

pujavipin

 Profile Answers by pujavipin 

• Jun 8th, 2009

 

LIKE - string pattern matching operator

    % = zero or many characters
    _(underscore) = one character.

yuvaevergreen

 Profile Answers by yuvaevergreen 

• Jun 14th, 2011

 

In teradata,

LIKE ALL, LIKE ANY are the operators.

saurabh

• Sep 5th, 2011

 

underscore operator (_) for single character matching n wildcard (%) for any length string matching...

example a column having abhi,abhaaa, bhaaa,bmddd,cmmm;and i want all those name that start with a then use like 'a%';