DEBUG SEARCH=[1500]

SQL INDUSTRIAL:
SELECT TOP 10 * FROM dbo.tblEquipPNs WHERE EquipType='Industrial' AND status='active' AND CAST(PartNumber AS NVARCHAR(255)) LIKE '%1500%' ORDER BY Retail ASC

AFTER OPEN (Industrial)
State=1
RecordCount=10

DEBUG INCLUDE: Industrial Equip PNs
IsObject(rsEquipPN) = True
State = 1
RecordCount = 10

PartNumber	Mfg	Category	Retail
115150005	General Electric	Control Board	$135.46
1500-5042	babcock	Circuit Board	$135.46
1500-5087	babcock	Circuit Board	$135.46
1SNA610059R1500	ABB Technology	Relay Module	$135.46
150028700	York	Control Board	$137.21
DS1500-3-001	sun fire	Power Supply	$137.75
2009-1500-08	general electric	Industrial	$137.92
915008147	avid digidesign	Industrial	$137.94
915008148	avid digidesign	Industrial	$137.94
915008154	avid digidesign	Industrial	$137.94