Can someone please provide assistance or guidance in how I can create a report where it displays a specific text within the 'Comments' field?

I've used the Wizard and compiled the SQL below:

SELECT [HD_workitem_current_view].[workitem_number] AS 'Incident Number', [HD_workitem_current_view].[workitem_created_on] AS 'Created On',
[HD_workitem_current_view].[workitem_comment] AS 'Last Comment',
[HD_workitem_current_view].[owned_by_worker_name] AS 'Queue',
[HD_workitem_current_view].[workitem_priority_lookup_value] AS 'Priority', [HD_workitem_current_view].[workitem_urgency_lookup_value] AS 'Severity', [HD_workitem_current_view].[workitem_category_tree_value] AS 'Category', [HD_workitem_current_view].[workitem_due_on] AS 'Due Date',
[HD_workitem_current_view].[workitem_status_lookup_value] AS 'Status' FROM [HD_workitem_current_view] INNER JOIN [HD_workitem_detail_view] ON [HD_workitem_current_view].[workitem_number] = [HD_workitem_detail_view].[workitem_number]
WHERE [HD_workitem_detail_view].[workitem_comment] LIKE '%Latest Update%' AND [HD_workitem_current_view].[workitem_status_lookup_id] < > 600 AND [HD_workitem_current_view].[workitem_type_lookup_id] = 5 ORDER BY [HD_workitem_current_view].[workitem_created_on] ASC

When the SQL is run, it shows ALL incidents which have 'Latest Update' within the comments - that's fine if the last comment had 'Latest Update....' on it.
However, if the 2nd last update was had 'Latest Update' within the comments field but then had 'Assigned to' as the last comment, the output has the 'Assigned to' comments instead.

I hope that I'm making sense and that someone can help me.