> 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