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


TIA,
mugi.






[Non-text portions of this message have been removed]