Text Data from SQL Query

Not sure if this is possible but figure i might a well ask.
I want to do an sql query that returns a number

SELECT PartStatus FROM [Thermoplastics].[dbo].[PartTracking] WHERE Container like '{Root Container.Container 1.text}'

But I want to display text such as ‘Operation 120’ when the query returns 65

You could do this with a long list of IF THEN or a CASE statement in the query, but you would be better off creating a Lookup table with the operation description linked to the PartTracking table.
Then you just join the tables inside the query and it will return the string value.