Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
SQL For Dummies. Hi... I'm a dummy.
DECLARE @sLED char(20); DECLARE @vLED char(20); SET @sLED = '{custitem97}'; SET @vLED = CASE @sLED WHEN 'Yes' THEN 'LED, ' ELSE '' END; DECLARE @sInc char(20); DECLARE @vInc char(20); SET @sInc = '{custitem98}'; SET @vInc CASE @sInc WHEN 'Yes' THEN 'Incandescent, ' ELSE '' END; DECLARE @sLShock char(20); DECLARE @vLShock char(20); SET @sLShock = '{custitem92}'; SET @vLShock = CASE @sLShock WHEN 'Yes' THEN 'Low Voltage Shock Protection, ' ELSE '' END; DECLARE @sHShock char(20); DECLARE @vHShock char(20); SET @sHShock = '{custitem93}'; SET @vHShock = CASE @sHShock WHEN 'Yes' THEN 'Insulated Shock Protection, ' ELSE '' END; DECLARE @sYFire char(20); DECLARE
0