I am using Microsoft SQL Server Management Studio 2008r. I am trying to create a query that will assign an ABC value based on a cost. I have no problems doing this in Access, buy SQL is just differenet enough to be a problem.
the component of the select statement is
if(im.cost_avg < 3,'C',if(im.cost_avg > 250,'A','B')) as ABC
I am not sure what I am missing.
Any help will be appreciated.