I am not sure I understood you 100%..but let me give it a shot..
For,
REPLACE transaccio WITH "Saldos" FOR SUBSTR(proglo,1,8)="BCLSCH30"
the SQL will be,
UPDATE "TableName" SET transaccio = "Saldos" WHERE SUBSTR(proglo,1,8)="BCLSCH30"
>Hello at alls;
>I wonder to know, How I have to do to add the above sentece in a query.
>I tryed with IIF() but the quantity of IIF is not enoth.
>TIA
>
>REPLACE transaccio WITH "Saldos" FOR SUBSTR(proglo,1,8)="BCLSCH30"
>REPLACE transaccio WITH "Historico" FOR proglo="BCLSCH33" OR proglo="BCLSCH33A" OR proglo="BCLSCH33C"
>REPLACE transaccio WITH "Movimientos" FOR proglo="BCLSCH30AR" OR proglo="BCLSCH31"
>REPLACE transaccio WITH "Historico año anterior" FOR proglo="BCLSCH34"
>REPLACE transaccio WITH "Tarjetas de credito" FOR proglo="BCLSCH67" OR proglo="BCLSCH67A" OR proglo="BCLSCH89" OR proglo="BCLSCH89A"
>REPLACE transaccio WITH "Saldos año anterior" FOR proglo="BCLSCH30SB"
>REPLACE transaccio WITH "Inversiones" FOR proglo="BCLSCH40C"
>REPLACE transaccio WITH "Diferidos" FOR proglo="BCLSCH32"
>REPLACE transaccio WITH "Creditos" FOR proglo="BCLSCH40"
- Jayesh