--- In firebird-support@yahoogroups.com, mugi yanto
<bantal_keyboard@...> wrote:

>
> Dear all,
>
> Would you please help me how to write the SQL syntax to modify my

table as shown below : ( I use FB 1.5)

>
> table_A
>
> klr                      date   
> ------------------       ----------
> -0808-00001       06.08.2008
> -0808-00002       06.08.2008
> -0808-00003       07.08.2008
>
> i would like to change the rows of field klr like this
>
> klr                           date
> -----------------------     ----------------
> FK1-0808-20001    06.08.2008
> FK1-0808-20002    06.08.2008
> FK1-0808-20003    07.08.2008
>

update Blah set
klr = 'FK1' || klr;

Adam