quote:

---

Originally posted by Oli4

Hey I'm very new in using SQL. I'm learning for the second week now.
I have to make a couple of exercises, but I'm struggling with some exceptions. I'm using SQL server management studio and MSQL server express.

I have a database called library and I have to put old or new next to the books from before or after 1980.

I already tried different things myself. Like this one:

Select title, year, test = case year
when year is > 1980 then 'new'
else 'old'
end
from BOEKEN

It's important to me to understand what I'm doing wrong, I get a syntax error near >
Can somebody explain if this is the right option and if working with the case function is nescessary.

I haven't learned anything about if then, or other programming structures yet.

thx

Here today, gone tomorrow

---