According to [email protected] > 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 --------------------------------------------------------------
