No answers yet, Luciano, just a few questions.

1) Which database version are you running (InterBase x.x/Firebird 1.x)?

2) What is the definition of aluno and matricula (field names and types)?

Set

At 11:42 20.06.2003 +0000, you wrote:

>Hi,
>
>The following (sequencia_paramper = 3) is gettin an error: "Cannot
>transliterate character between character sets"
>
>If I remove this part, the select works whithot error.
>The field 'sequencia_paramper' is a smallint type.
>The ones 'periodoano_matr' and 'periodoano_paramper' are Char(6).
>The entire select is below:
>
>select id_aluno, nome_aluno, cod_matr, linhacron_matr, periodoano_matr
>from aluno
>left join matricula
>on idaluno_matr = id_aluno
>join param_per
>on (periodoano_paramper = periodoano_matr)
>where (periodoano_matr <> '3/2003') and
>(sequencia_paramper = 3)
>
>I moved the "bad" part from select to join without success.
>
>What could be wrong??