According to rouzen AT univ.haifa.ac DOT il
> Hi All
>
> Need a little help with this script
>
> select cast(node_name as varchar(20)) as "Nodebane" , cast(TCP_ADDRESS as 
> varchar(15)) as "IP" ,  cast(CLIENT_OS_NAME as varchar(35)) as " OS Name"   , 
> cast(CLIENT_SYSTEM_ARCHITECTURE as varchar(4)) as "BIT" , 
> cast(APPLICATION_VERSION as varchar(2)) as "Aooplcation Version", 
> cast(APPLICATION_RELEASE as varchar(2)) as "Applcation Release", 
> cast(APPLICATION_LEVEL as varchar(2)) as "Application Level" , 
> cast(APPLICATION_SUBLEVEL as varchar(2)) as "Application Sublevel" from nodes 
>  where (node_name like ('%%_DB')  and node_name not like ('DRM%%')) order by 4
>

Try the following:

select node_name from nodes where node_name like '%\_SQL' escape '\'

The character "_" matches excactly one character.
Therefore you must escaped it.


Heinz

--------------------------------------------------------------
Karlsruher Institut fuer Technologie (KIT)
Steinbuch Centre for Computing (SCC)

Heinz Flemming
Scientific Data Management (SDM)

76131 Karlsruhe

KIT - Die Forschungsuniversitaet in der Helmholtz-Gemeinschaft
--------------------------------------------------------------