How to remove the last character from a field in Firebird SQL

Question

I have a field in a table that should only contain 4 characters, I realized that the same is with 5 characters and the last is the number zero.

Example:

Código Errado: 45380
Código Correto = 4538

Delete the last character of a field in Firebird SQL?

Answer 1

You can use CHARACTER_LENGTH:

UPDATE minhaTabela
SET    minhaColuna = Substring(minhaColuna FROM 1 FOR 4)
WHERE  Character_length(minhaColuna) = 5  

This way only where there are 5 characters will be removed the last.

Answer 2

Just make a UPDATE by dividing the value by 10.

update minhaTabela
set Campo = Campo/10
where [...]

Answer 3

Have you tried using the method strlen?

   UPDATE suatabel SET campo = SUBSTR(campo , 1, strlen(campo)-1)
    where strlen(campo) = 5;