Hi, I got that sorted. Sorry, I kind of lead you up the garden path, not purposely of course!

I thought the view worked, well, it did but I was 'unionising'

two...

Yeah, here it is, thanks.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[Messages_Select]

@User_ID int,

@PageIndex int,

...