Subject Re: [ib-support] error in CAST
Author José M.Llanes
hi,
try "CAST(nota AS varchar(nnn)),"
when nnn is your size of nota.

José





> I receive an error when I try to make this command in a stored
> procedure:
>
> error: "Token unkown ... varying"
>
> insert into DISCIPLINA_HISTORICO (ID_PARCEIRO,
> ID_TIPO_CURSO,
> SERIE,
> APROVEITAMENTO,
> CARGA_HORARIA,
> FALTAS_HORAS)
> values (:aluno,
> :tipo_curso,
> :serie,
> CAST(nota AS varying
> character),
> :falta);
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>