Select Business Solutions

NOMAD & UltraQuest Newsletter

June 2011

June 2011 Contents

Social Media

How To:

Request DR CPUID

UltraQuest Webinars

Product Suggestions

Contact Information

Social Media

facebook & YouTube

Select Business Solutions is on facebook and now YouTube.

Select Business Solutions will begin posting answers to frequently asked questions such as compatibility with new releases of operating systems, data sources & web browsers. We also will be posting technical information on NOMAD/UltraQuest features and functions that users may want to use and not be aware of to make reporting easier.

To follow Select Business Solutions click on the logo, once in facebook click the LIKE button.

We have posted samples of our video-based training on a wide range of software engineering, project management and IT subjects. We have over 130 hours of high quality video, available for use in the classroom, via Virtual Learning Environments (VLEs) or DVD for distance learning. To learn more visit our website by clicking here

Click on the logo and check out the samples and click subscribe to be notified when new videos are loaded.

How To...

Joining/Concatenating alphanumeric fields

Have you ever been working with alpha fields and wish you could join them together? There are built in functions in NOMAD and UltraQuest that make this easy. Below are two fields FIRST_NAME and LAST_NAME and we want to join the two fields together with a space between the fields.

Item FIRST_NAME A20 = 'Dennis '

item LAST_NAME A20 = 'Street '

Desired Result = Dennis Street

Functions CAT & CATB allow you to join or concatenate alphanumeric fields together into a single field in a Define or expression.

CAT - Concatenates two fields together into one field.

Define or expression = FIRST_NAME CAT LAST_NAME

Result = 'Dennis Street '

You will notice there are several blanks between FIRST_NAME and LAST_NAME. We want only one space between the fields.

CATB - Concatenates two fields together just like CAT but removes the trailing blanks from the first field.

Define or expression = FIRST_NAME CATB LAST_NAME

Result = 'DennisStreet '

You will notice that all of the blanks have been removed from FIRST_NAME but now we are missing a blank between FIRST_NAME and LAST_NAME. We are close but we need to have a blank between the fields.

So we will need to use both CAT and CATB to get the desired result. We will add a space or ' ' to our expression

Define or Expression = FIRST_NAME CATB ' ' CAT LAST_NAME

Result = 'Dennis Street '

This is exactly what we are looking for in our result.

Need a Disaster Recovery CPUID

for a Test or Actual Disaster?

Have you ever needed to get a DR CPUID and didn't know who to contact?

Below are the procedures to get a DR CPUID.

DR Test:

Email the information below to This email address is being protected from spambots. You need JavaScript enabled to view it.

Company Name

Account Number

Test Start Date

Test End Date

Email Address to send CPUID

If test is longer then 5 days also include:

DR CPUID Model, Sub-Model & Serial Number.

Actual DR Production System is Down:

Same as above but also call the support line at 1-888-328-7806 in the US or outside the US call 1-203-383-4709, support will be paged immediately.

UltraQuest Demonstrations

Featuring the Latest Release, Version 5.5

Sign up now for an UltraQuest demo and see the new Reporter desktop plus other new facilities in version 5.5!

If you want to see UltraQuest in action and these dates aren't convenient for you, please contact Dennis Street at This email address is being protected from spambots. You need JavaScript enabled to view it. or call 972-899-5221 to schedule a time.

Product Suggestions

We want to hear from you!

Select Business Solutions has always based product development and enhancements on the feedback we get from our customers. Recent additions like the interfaces to Oracle and SQL Server and the UltraQuest Scheduler were based directly on requests from our customer base. We pride ourselves on being responsive to our customers’ needs and the changing IT environment, and we want to hear from you. If there is a product feature you would like to see added, or if you have any suggestions on how to make our products better please email them to us at This email address is being protected from spambots. You need JavaScript enabled to view it..

35 Nutmeg Drive

Trumbull, CT 06611

Phone: 1-888-472-7347

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

If you do not wish to receive future e-mails from

Select Business Solutions, please email: This email address is being protected from spambots. You need JavaScript enabled to view it.