i have a table wich i need to update
my intention is to update the field increasing 100 to its current value, unfortunately that value is stored as string
for example '0165' would like to turn it into "0265'
so my approach was to use cast to turn that into a value increase it by 100 then turn it into a character and padding it with a 0, but the next statement is not working, im very new to firebird and i was looking for a TONUMBER or VAL function, im most used to oracle and/or mssqlserver
CHECADAS.CH_H_REAL='0'||cast(CAST(CH_H_REAL AS NUMERIC)+100 as character(800))
CH_H_AJUS = '0630';
please help this is urgent, that system didnt consider day time savings and i need to update the records (check in time values) for all those who checked-in with a wrong time (one hour ahead of time)