Nice one!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Reese,
Michael A (Mike) CIV USARMY 93 SIG BDE (US)
Sent: Wednesday, February 04, 2015 8:53 AM
To: ADSM-L@VM.MARIST.EDU
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 [ADSM-L@VM.MARIST.EDU] on behalf of David
Ehresman [david.ehres...@louisville.edu]
Sent: Wednesday, February 04, 2015 8:36 AM
To: ADSM-L@VM.MARIST.EDU
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
