Hi SQL gurus,
I need to thank you ahead of time for even reading this post as I am a newb to SQL server. Below is a field in a database that has a delimiter of "|" and I need to break up that value every time the "|" appears.
Value In Database:
Item - Felt Strip | Type - General Purpose | Material - Wool Felt | Backing Type - Plain | Thickness - 1/4" | Width - 1" | Length - 12" | Grade - F5 | Color - Off White | Density (Lbs./Sq. Yd.) - 3 | Min. Temp. Rating (Deg. F) - -80 | Max.
Temp. (F) - 200 | Vibration Absorption - Medium | Abrasion Resistance - Good | Durometer - 20 to 30 Shore A | Tensile Strength (PSI) - 400 | Hardness - Medium | Application - For Dust Shields, Bumpers, Pads, Wipers
Value I need to report:
< ...
Go to the complete details ...