thanks

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer
<ts@i...> wrote:

> > i want to make something like this
> >
> > Var1 = left(:var2,4) + '00';
>
> You can do that easily by using the built-in SUBSTRING function.
>
>
> Var1 = SUBSTRING(var2 FROM 1 FOR 4) || '00';
>
>
> --
> HTH,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database and MS SQL Server
> Upscene Productions
> http://www.upscene.com