Nice one! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Reese, Michael A (Mike) CIV USARMY 93 SIG BDE (US) Sent: Wednesday, February 04, 2015 8:53 AM To: [email protected] Subject: Re: [ADSM-L] Query syntax
select char(node_name,50) as "Node Name", cast(client_version as char) || '.' || cast(client_release as char) || '.' || cast(client_level as char) || '.' || cast(client_sublevel as char) as "Version" from nodes ________________________________ From: ADSM: Dist Stor Manager [[email protected]] on behalf of David Ehresman [[email protected]] Sent: Wednesday, February 04, 2015 8:36 AM To: [email protected] Subject: [ADSM-L] Query syntax What is the select statement syntax for concatenating client_version,client_release,client_level,client_sublevel from the nodes table into a single string, e.g. 7.1.1.3? David
