On Thu, 28 Aug 2014 10:32:51 +0200, "Svein Erling Tysvær
svein.erling.tysvaer@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:

>>Perhaps my problem is in an incorrect installation setting? 
>>I have FB 2.5.3 on a laptop. Win 7 32 bit.
>>I introduced a stored procedure and in it call F_LEFT(:varName, 24) to
>>truncate :varName from a vc(48).
>>This DB is used in Win 7 and win 8.1 else where without problem.
>>
>>When I run the procedure on this one box I get 
>>
>>ISC error 335544343
>>invalidrequest BLR @offset2452
>>function F_LEFT is not defined
>>module name or entry point could not be found
>>Error while parsing procedure myProc's BLR
>>
>>I reinstalled Firebird.
>>I did a backup and restore of the DB. 
>>No improvement.
>>
>>Any advice for me, beside &quo t;work smarter"?
>
> I think this is saying that you have not installed the UDF function
> F_LEFT. I don't think there is any function with that name natively in
> Firebird (you can find it in FreeUDFLib, but then you need to install

it),

> but I could be wrong.
>
> Generally, I think I would recommend you to use SUBSTRING(:varName FROM

1

> FOR 24) rather than F_LEFT.

Or simply use the built-in function LEFT:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-left.html