Hi.

Did you declare the standard UDF function "rtrim" -
If so, simply use:

UPDATE mytable
SET mycolumn = rtim(mycolumn)

> I noticed that on of my tables had CHAR(30) field instead VARCHAR
> I converted the field with small script, but the spaces at the end of data

came also over.

> Now I have "Riho ", but I want to have "Riho".
> Is it possbile to easily get rid of these spaces using Firebird ?

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com