Hi all,

Thank you for your replies. I apologize that I haven't been as clear. I'm actually learning how to use the backend part of SQL on a CMS platform. If I don't answer your question directly, its probably because I didn't understand it so I will try to explain it the best way I know.

To answer Craig's question, yes what I pasted was the full "Update" statement or the full code. I am using a pre-built TEM platform and when I go into the option of creating a report to extract information from the database (or to change it), it doesn't really show me all the table names etc. It just shows me all the field names and if I click on the field I want to update, the field name is populated in the SQL code box. That is how i got the "[Inventory item.Personnel.Transit.Department]". Also, because it is pre-built, I didn't name the tables. This is how the application was setup by whoever built it I guess.

I wasn't sure if I should use SET or UPDATE for what I'm trying to achieve. I just learnt that in a basic SQL course so I was trying to see if that will fix it. What I was trying to do is put a fixed value in a column.

Would you suggest that I take some other courses to better understand what I want to achieve? Any recommendations?

Thanks in advance and sorry for the confusion.