ra.shinde

 Profile Answers by ra.shinde 

• Jan 5th, 2009

 

Use Like '%_%'

cybersavvy

 Profile Answers by cybersavvy 

• Feb 4th, 2009

 

select col_name from table_name where col_name like '%_%' Escape ''

cybersavvy

 Profile Answers by cybersavvy 

• Feb 5th, 2009

 

select colname from table_name where colname like '%_%' Escape ''

Lani_dba

 Profile Answers by Lani_dba 

• Mar 24th, 2009

 

select * from table where column like '[_]%'

sanjeev02

 Profile Answers by sanjeev02 

• Mar 26th, 2009

 

The Exact Syntax would be:
select * from table where column like '%[_] %'

It would show all the items containin '_' in between.

prathima

 Profile Answers by prathima 

• Jul 22nd, 2009

 

use escape  keyword to fetch the strings with wildcard characters.
eg: select * from table_name where column_name like 'canara!_!_%' escape '!'

above query will return records with attribute value canara__

goksn

 Profile Answers by goksn 

• Sep 23rd, 2009

 

select * from table_name where column_name like '%_%'

dh09121975

 Profile Answers by dh09121975 

• Oct 6th, 2009

 

SELECT * FROM table
WHERE Column LIKE '%[_]%'

balaji.psnacet

 Profile Answers by balaji.psnacet 

• Oct 21st, 2009

 

Try this ..
SELECT * FROM table_name WHERE column_name LIKE'%!_%' ESCAPE '!'

Bhuvaneswari.V

 Profile Answers by Bhuvaneswari.V 

• Nov 2nd, 2009

 

SELECT * FROM TableName WHERE ColumnName LIKE '_%[_]%_'

psingla

 Profile Answers by psingla Questions by psingla

• Mar 3rd, 2010

 

SELECT login

FROM table_name

WHERE Charindex('_',Ltrim(Rtrim(column_name))) = (Len(Ltrim(Rtrim(column_name)/ 2)+ 1

psingla

 Profile Answers by psingla Questions by psingla

• Mar 16th, 2010

 

SELECT column_name FROM table_name                                                                                                           WHERE Charindex('_', Ltrim(Rtrim(column_name)))= (Len(Ltrim(Rtrim(column_name)))/ 2)+ 1

sonudotnet

 Profile Answers by sonudotnet Questions by sonudotnet

• Mar 17th, 2010

 

select * from emp where ename like '%[_]%' S

Srikanth Pathem

DeepakMohapatra

 Profile Answers by DeepakMohapatra 

• Apr 15th, 2010

 

SELECT * FROM TableName WHERE ColumnName LIKE '%[_]%'

Rohit_1987

 Profile Answers by Rohit_1987 

• May 25th, 2010

 

Select * from tableName where colName LIKE '%'+'_'+'%'