yeah, this works.

Thanks,

I need to get the last value regardless of the actual date.

I tried both solutions and both work.

Thank you.

Thank you, this last solution works.

Yes, it is. Thank you...

Kraig,your sample code works.

Thank you.

Here I am adding the insert statements to add the data to the tables.

Thanks,

Insert into table2

VALUES ('IN', '12089030', 'HO', ...

Thank you..

Thank you all again. WayneS' solution works.

Than you for the suggestion.

Thank you, both solutions work.

Thanks again.

It is easier to implement.

Thank you, the function below worked..

select stuff('PQ19188PFHAA',10,1,'')

Thanks again.

The problem is that this character is not always H, it can be any character. How can I use the Len function to get a fixed character in the...

Scott, this worked perfectly. Thank you and thanks to all...

Jose

Thanks for looking into this issue..

Note: I added more info on table schema and sample data in a different format.

USE [TestDB]

GO

/****** Object: Table [dbo].[tblZGAE3HJ] Script Date:...