Alan,

Thanks a lot for your response.

Fabian



--- Alan McDonald <alan@...> wrote:

> > >>I have an App that uses "Insert into Table
> Select Varchar ....
> > >>
> > >>The problem is that sometimes the Varchar is
> "bigger" than the defined
> > >>receiving field. Is there any way to "truncate
> on the fly"... so the
> > >>app can insert regardless of the size of the
> "selected" field?
> > >
> > > Yes. Use CAST( aVarchar as Varchar(n)), where n
> is the size of the
> > > target column.
> >
> > CAST can't truncate string (only if cut characters
> are spaces).
> >
> > CAST is done implicitly in "Insert into Table
> Select Varchar",
> > so you know it can't work.
> >
> > Ivan
> >
> > >
> > > An alternative is to use the internal function
> SUBSTRING() to limit
> > > the size of the string, viz. SUBSTRING(aVarchar
> from 1 for n) where,
> > > again, n is the size of the target column.
>
> hmmm,, dead right - seems I have a bit of work to
> do. - seems I've been
> lucky that spaces were neing truncated.
> :-)
> Alan
>
>
>

Fabian Chocron

This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both
No confidentiality or privilege is waived or lost by any miss transmission. If you receive this correspondence in error,
please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this
correspondence if you are not the intended recipient. Any views expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be the views of: “IT Bizolutions Pty. Ltd.”

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com