>Hi
>
>How would I modify this SQL statement so that if a MessageID exists in both tables, the resulting table should ONLY take the record from the ApplicationMessage table?
>
>select * from dbo.SystemMessage where MessageID = @LnMessageID
> union all
>select * from dbo.ApplicationMessage where MessageID = @lnMessageID
>order by MessageID
>
>Regards

BTW, I noticed that you never respond back if the answer satisfies you - IMHO, you should somehow aknowledge this, because otherwise it's not clear if the solution worked for you or not.