Query syntax

2015-02-04 Thread David Ehresman
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

Re: Query syntax

2015-02-04 Thread Reese, Michael A (Mike) CIV USARMY 93 SIG BDE (US)
rom: 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

Re: Query syntax

2015-02-04 Thread Jeanne Bruno
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