Hi!

I have a file that has this values:
12777,85E
53873,08E
10652,47E
7493,99E
88475,70E
57497,78E

I want to make an sql statement where i substitute the 'E' by a ' '.
I made this sql but it doesn't function.

update mybibl/fichspool
set substr(fichspool, 67, 1)=' '
where substr(fichspool, 67, 1) ='E'
Token ( was not valid. Valid tokens: =.

67 is the position in the file where the caracter is.

Any suggestions?

Try:

update mybibl/fichspool
set fichpool = substr(fichpool,1,66) || substr(fichspool, 68)
where substr(fichspool, 67, 1) ='E'

Andy

Thank's, it solved!