I have a simple click view with one table creating a Data Dictionary.
LOAD ServerName AS [Server Name],
DatabaseName AS [Database Name],
SchemaName AS [Schema Name],
ObjectName AS [Object Name],
ObjectType AS [Object Type]
I want to take the Server Name field and parse it so that I get the last portion of the Server Name which is its Instance into another field. I want to create a list box so when you click a instance type the server name field only shows those types of servers.
Example of Server Names
DEV, QA, AND PROD will be in another ListBox where if clicked the Server Names list box only shows the servers with that instance type.