If MarkP is correct on the format, where you want to remove the last 4 characters, why not use this:

SUBSTRING(@var, 1, LEN(@var) - 4)

Replace the @var with your field value.

What's it say about us that only two people are willing to admit to making mistakes?

I can think of several mistakes I've made just in the last week.

After month's of...

I'm happy with where I work today.  I hope to ride it out until retirement, 8 to 10 years or so.  I decided after I lost my job over 6...

That'll be a lot of time in an airport or airplane in one year.

Saw some similar views las month of the mountains as we flew through Denver to Hawaii(and back).  Well the wife saw more of it since she was by the window,...

Only been to one on your List Honolulu, passed through Miami and Chicago, both flying and driving.

Places we still want to see are:

Italy, England, France, Spain, Australia, New Zeeland, the Maldives, Fiji, Bora...

I'm trying to get it to be a team, not a developer.  I would prefer it to be the same team that is responsible to do our server moves, it's...

Bay

I don't need a third space.  I prefer the WFH, hope we aren't required to come back in full time.  They say we can work from anywhere, but I would...

I didn't have any issues with CHAR columns lately, but we have had to adjust the size on our claim number(was char(8)) and policy number(was char(9)) sizes in...

I didn't have any issues with CHAR columns lately, but we have had to adjust the size on our claim number(was char(8)) and policy number(was char(9)) sizes in the last...

Jeff said

"The answer is simple... because it's not bullet proof and it actually takes less effort to make it bullet proof.  I've seen too many times where people have changed...

I agree with a lot of what you said Jeff, but I can't agree here.   I've worked at...

Overboard

Anyone still playing this late in the year?

Another 24 shot game.

Kind of a slow week for me. 😉