Thanks Svein, yes that would work, but I'm more concerned that previous
udfs fail - this is just one example I've tested. What about all the
other Udfs - in multiple databases? I know that I (plus anyone else) can
perform a search and replace on all SPs - but what if I miss one?
I guess what I'm trying to say is "Why does it now fail?"

Regards
Alan
Alan J Davies
Aldis

On 29/03/2011 10:56, Svein Erling Tysvær wrote:
> What about trim(coalesce(partno_prefix, ''))
>
> HTH,
> Set
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>] On Behalf Of Alan J Davies
> Sent: 29. mars 2011 10:58
> To: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> Subject: [firebird-support] Alltrim UDF in FB 2.5
>
> Hi, I'm trying out 2.5.0.26074 against existing 2.1.3.18185 databases.
> Clean install on XP
>
> This code in 2.5 gives error "Connection was lost to database:"
> (Crashes - I can then restore connections with no problem.)
> select
> '*'||alltrim(partno_prefix)||alltrim(Partno)||alltrim(partno_suffix)||'*' from
>
> part_table
> It works perfectly in 2.1
> Its used to generate barcodes, hence the * and the need to use alltrim.
> Trim does not work because if there is no partno_prefix or partno_suffix
> it gives a null result as the concatenation.
>
> I recall seeing some information about certain Udfs now being native in
> Firebird, but can't remember where or when, and I've checked my own
> documentation.
>
> The Alltrim udf is part of fudlib.dll.
> Can anyone point me in the right direction, please.
>
> Regards
> Alan J Davies
> Aldis
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
> ------------------------------------------------------------------------
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 10.0.1204 / Virus Database: 1498/3536 - Release Date: 03/28/11
>