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 Got output: Nodenane IP OS Name BIT Application Version Application Release Application Level Application Sublevel --------------------- ---------------- ------------------------------------ ----- -------------------- ------------------- ------------------ --------------------- HPLDB 132.74.1.210 AIX:AIX PPC EXCHSRVAN_DB 132.74.1.226 WIN:Windows Server 2008 R2 x64 7 1 4 0 EXCHSRVBN_DB 132.74.1.227 WIN:Windows Server 2008 R2 x64 7 1 4 0 Why the line: HPLDB appears !! I specific node_name like(‘%%_DB’) ????? Ideas ??? Best Regards Robert [cid:image001.png@01D1284F.C3B0B400]<http://computing.haifa.ac.il/> רוברט אוזן ראש תחום שרידות וזמינות נתונים. אוניברסיטת חיפה משרד: בניין ראשי, חדר 5015 טלפון: 04-8240345 (פנימי: 2345) דואר: rou...@univ.haifa.ac.il _____________________________________________________ אוניברסיטת חיפה | שד' אבא חושי 199 | הר הכרמל, חיפה | מיקוד: 3498838 אתר אגף מחשוב ומערכות מידע: http://computing.haifa.ac.il<http://computing.haifa.ac.il/>