Remove last 3 charecters in column

Question

Hi,

I need to remove three characters(.00) in below table

result:

111111111 without (last three characters i.e .00)

chr
1111111111.00
11111111.00
11111111.00
1111111111.00
1111111.00
111111.00
11111111.00
1111.00
1111111.00

Accepted Answer

Hi @mrrobottelg

I need to remove three characters(.00) in below table

You could use the LEFT function like this:

SELECT LEFT(YourColumn, LEN(YourColumn) - 3) AS ModifiedColumn
FROM YourTable
WHERE LEN(YourColumn) > 3;

And update the column to remove the last three characters like this:

UPDATE YourTable
SET YourColumn = LEFT(YourColumn, LEN(YourColumn) - 3);
WHERE LEN(YourColumn) > 3;

Best regards,

Cosmog

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer

A simple UPDATE will do the job

UPDATE YourTable
SET yourColumn = REPLACE(yourColumn, '.00', '')
WHERE yourColumn LKIE '%.00'

Share via

Remove last 3 charecters in column

1 additional answer

Your answer