SQL Server Query
- by Scott Jackson
Hi,
I'm trying to do some work with my SQL table.
I have 2 buildings with room numbers 1 - 100 in building 1 and 101 - 199 in building 2.
I have a location field (which I've just created) and want to run a query to populate it with either 'Building 1' or 'Building 2' depending on which room number it has in the 'Room' field.
Many thanks for your help.
Regards
Scott