The data I am looking for to be returned from a select statement is the 2 or 3 digit number to the right on the text ' CNT'
I hope this is what you were looking for and after reviewing the post Forum Etiquette: How to post data/code on a forum to get the best help.
Thank you.
--===== Create the test table with
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PART](
[ROWID] [int] IDENTITY(1,1) NOT NULL,
[ID] [nvarchar](30) NOT NULL,
[DESCRIPTION] [nvarchar](120) NULL
CONSTRAINT [PK_PART] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
--===== All Inserts into the IDENTITY column
SET IDENTITY_INSERT PART ON
--===== Insert the test data into the test table
INSERT INTO PART
(ID, DESCRIPTION)
SELECT 'AMB-02','LOVIDIA 30 CNT/BT, REGULAR', UNION ALL
SELECT 'AMB-03','GLP1 SUPPORT 60 CNT/BT', UNION ALL
SELECT 'DEV-02','DEVROM CHEWABLE 100 CNT BT', UNION ALL
SELECT 'DOT-01','ZENDOCRINE 60 CNT/BT, CAPS', UNION ALL
SELECT 'DOT-04','US DIGESTZEN, US 100 CNT/BT, TB', UNION ALL
SELECT 'LIF-06','PROTANDIM NRF2 (US) 30 CNT. BOTTLE', UNION ALL
SELECT 'LIF-07','PETANDIM FOR DOGS, 30 CNT BT (US)', UNION ALL
SELECT 'LIF-09','PROTANDIM NRF2 30 CNT (JP)', UNION ALL
SELECT 'LIF-10','PROTANDIM HK 30 CNT. BOTTLE (HK CHI)', UNION ALL
SELECT 'LIF-12','PROTANDIM CA 30 CNT. BTL (CA ENG/FRE)', UNION ALL
SELECT 'LIF-13','PETANDIM FOR DOGS, 30 CNT BT (JP)', UNION ALL
SELECT 'LIF-22','PROTANDIM NRF1 JP 60 CNT. BT', UNION ALL
SELECT 'LIF-23','PROTANDIM NRF2 TH 30 CNT. BT', UNION ALL
SELECT 'LIF-25','PHYSIQ FAT BURN JP 120 CNT. BT', UNION ALL
SELECT 'LIF-26','PROTANDIM NRF1 TH 60 CNT. BT', UNION ALL
SELECT 'LIF-27','PROTANDIM NRF1 EU 60 CNT. BT', UNION ALL
SELECT 'LIF-29','PROTANDIM NRF2 MX 30 CNT. BT', UNION ALL
SELECT 'LIF-30','PROTANDIM NRF1 CA 60 CNT BT ', UNION ALL
SELECT 'LIF-31','PROTANDIM NRF1 MX 60 CNT. BT', UNION ALL
SELECT 'LIF-32','PROTANDIM NRF1 60 CNT US ENG, BT ', UNION ALL
SELECT 'LIF-33','PROTANDIM NRF1 60 CNT HK ENG, BT ', UNION ALL
SELECT 'LIF-34','PROTANDIM NRF2 TW 30 CNT. BT', UNION ALL
SELECT 'NUS-08','BOTANAGAR 120 CNT/BT (TAIWAN)', UNION ALL
SELECT 'NUS102','VITOX 180 CNT/BT (JAPAN), CAPSULE', UNION ALL
SELECT 'NUS120','TeGREEN 30 CNT/ BT (JAPAN), CAPS(KENKO)', UNION ALL
SELECT 'NUS141','METABOTRIM DIET (JP) 60 CNT/BT , CAPS', UNION ALL
SELECT 'NUS145','SEASONAL CARE 90 CNT/BT (JP), CAPS', UNION ALL
SELECT 'NUS169','DETOX FORMULA 60 CNT/BT (US), CAPSULE', UNION ALL
SELECT 'NUS170','TEGREEN 120 CNT/BT (SG)', UNION ALL
SELECT 'NUS172','BIO GINKGO 60 CNT/BT (MY)', UNION ALL
SELECT 'NUS184','DIGESTIVE FORMULA 30 CNT (TW) BT', UNION ALL
SELECT 'NUS217','FLEX FORMULA 120 CNT/BT (SG)', UNION ALL
SELECT 'NUS218','TEGREEN 30 CNT/BT (INDONESIA)', UNION ALL
SELECT 'NUS221','PROBIO PCC (KO) 30 CNT/BT', UNION ALL
SELECT 'NUS222','PROBIO PCC (TW) 30 CNT/BT', UNION ALL
SELECT 'NUS224','PROBIO PCC (JP) 30 CNT/BT', UNION ALL
SELECT 'NUS225','PROBIO PCC (SG) 30 CNT/BT ', UNION ALL
SELECT 'NUS227','REISHIMAX 60 CNT/BT (MY) CAPSULE', UNION ALL
SELECT 'NUS229','BIO GINKGO REFORMULATED 60 CNT/BT', UNION ALL
SELECT 'NUS238','PROBIO PCC (HK) 30 CNT/BT ', UNION ALL
SELECT 'NUS246','REISHI EX 60 CNT/BT (JP), CAPSULE', UNION ALL
SELECT 'NUS259','BIO GINKGO 27/7 60 CNT/BT (HK)', UNION ALL
SELECT 'NUS260','BONE FORMULA (US) 180 CNT/BT', UNION ALL
SELECT 'NUS265','UNFG COMPLEX F (EU) 120 CNT BTL', UNION ALL
SELECT 'NUS266','ESTERA PHASE II TRANSITION (US) 30CNT/BT', UNION ALL
SELECT 'NUS267','ESTERA PHASE III MAINTENANCE (US) 60 CNT', UNION ALL
SELECT 'NUS275','TeGREEN 30 CNT/ BT(MX), CAPSULES', UNION ALL
SELECT 'NUS276','GENLOC TR90 FIT JAPAN 90 CNT BOTTLE ', UNION ALL
SELECT 'NUS279','PROBIO 30 CNT/ BT (US), CAPSULES', UNION ALL
SELECT 'NUS280','CORTITROL 60 CNT/ BT (US), CAPSULES', UNION ALL
SELECT 'NUS290','UNFG REISHIMAX 60 CNT/BT (EU), CAPS', UNION ALL
SELECT 'NUS292','DIGESTIVE FORMULA (US) 60 CNT/BT', UNION ALL
SELECT 'NUS293','ESTERA CRANBERRY 60 CNT/BT (US)', UNION ALL
SELECT 'NUS303','UNFG BONE FORMULA (EU) 180 CNT/BT', UNION ALL
SELECT 'NUS313','PROBIO UNFG 30 CNT/ BT (EU), CAPSULES', UNION ALL
SELECT 'NUS318','CORTITROL (HK 2017) 60 CNT/BT ', UNION ALL
SELECT 'NUS319','UNFG JUNGAMALS 90 CNT/BT (HK)', UNION ALL
SELECT 'NUS-41','LIFEPAK TEEN 120 CNT/BT, US', UNION ALL
SELECT 'PYC-08','PBGS+ 60 CNT/BT', UNION ALL
SELECT 'PYC-09','PBGS+ 120 CNT/BT', UNION ALL
SELECT 'PYC-11','PBGS+ 120 CNT/BT (KOREA)', UNION ALL
SELECT 'PYC-12','PBGS+ 60 CNT/BT (MEXICO)', UNION ALL
SELECT 'SHA-28','RITESTART KIDS & TEENS 120 CNT/BT', UNION ALL
SELECT 'SHK-11','HERB-LAX 240 CNT TAB US (KOSHER)', UNION ALL
SELECT 'SHK-12','HERB-LAX 60 CNT TAB US (KOSHER)', UNION ALL
SELECT 'SHK-14','HERB-LAX 240 CNT TAB CAN', UNION ALL
SELECT 'SHK-21','PHYTOCOL-ST TB,120 CNT BT, MY ', UNION ALL
SELECT 'SIM-01','BABY GUM RELIEF TB 135CNT', UNION ALL
SELECT 'TWI-20','RESVITAL RESVERATROL 500MG 60CNT', UNION ALL
SELECT 'TWI-21','RESERVEAGE KERATIN BOOSTER W BIOTIN 60CNT', UNION ALL
SELECT 'TWI-24','RESERVEAGE TRES BEAUTY 3 90CNT', UNION ALL
SELECT 'TWI-25','RESVITAL BEAUTY 3 90CNT', UNION ALL
SELECT 'TWI-27','RESERVEAGE BEAUTIFUL LEGS W/DIOSMIN 30CNT', UNION ALL
SELECT 'TWI-29','RESERVEAGE PROSTATE SCIENCE 60CNT', UNION ALL
SELECT 'TWI-30','RESERVEAGE KERATIN BOOSTER W/BIOTIN FOR MEN 60CNT', UNION ALL
SELECT 'TWI-47','RSV BEAUTIFULORA 60CNT', UNION ALL
SELECT 'YOU-07','ESSENTIALZYME 90CNT BI-LAYER TAB. BOTTLE'
--===== Set the identity insert back to normal
SET IDENTITY_INSERT PART OFF