Discussions
-
Returning all the same value.
I got this code to work, well kind of. Its only returning 110 CASE When Actual bid 2 >2700 THEN 120 When (model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110 ELSE 110 END Tried this CASE When Actual bid 2 >2700 AND model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%' THEN 110 when 'actual bid 2' <=2700 then…
-
I need syntax help. Bit of a newbie trying to teach themselves IF/LIKE/OR
The specific task is to identify if a truck is a F-250,350, 2500, or 3500. The Column is "model" that I'm looking for the partial match in the model column. I keep getting syntax errors. CASE WHEN `model`LIKE ‘%F 250%’ OR `model` LIKE ‘%F-250%’ OR `model` LIKE ‘%F250%’ OR `model` LIKE ‘%E-350%’ OR `model` LIKE ‘%E-250%’ OR…
