Hi Lynn

Awesome!:-)

Cheers for the help and the links...ill check them out.

A

Hi Lynn

Sorry, still a bit vague for me.

The table name is Branch and the column is called branchcode.

It should be some kind of update statement?

Thanks

A

Thank you Kish...your suggestion worked!:-)

Hi

Thanks you for the reply

I just need the > symbol and the 4 characters after it

All the data is consistent in character length

A

Thank you for the response Happycat:-)

Hi Dwain

"Why can't you just add up the 7 days and show that as the Total?"

That's perfect, that is actually hat I want to do

Its more a reporting script than...

Thanks Luis

Code column is (Varchar(400),Null)

Csimplecode Column is (Varchar(20),Null)

However none of the data is longer than 20 Characters

Your help is appreciated.

A

Thnk you luiz

Worked like a charm.

I am also trying to copy data from one column to the other and get the following error

Here is the statement

update stkitem

SET Csimplecode=Code

and the error...

Hi Luis

PERFECT...right on the money.

Much appreciated!

Everyone else, Thank you for you contributions too!

Hi Piet

Yes and thanks in advance

Hi SSCveteran

Thanks you for the assistance, worked great.

Im pretty new to this and appreciate the assistance.

A

Hi Miste.Magoo

Thanks for that, worked like a dream.

Appreciate the assistance!:-)

A

Hi Again

Further to this I have also tried the following

UPDATE tablename

SET column = Ltrim(column,'0');

But i get this when I parse

Msg 174, Level 15, State 1, Line...