Hi Helen,

Thanks for the response, it actually put me on the right track for a
solution

>.... this should give you the transliteration you want:
>select
>cast((ORDERREFERENTIE) as char(10) character set WIN1252) MyField
>from TBL_ORDER
>WHERE ORDERNUMMER='1481351-1'

With some modification this actually worked on 1.53 !

select
cast (
(cast( ORDERREFERENTIE as char(10) character set UNICODE_FSS) ) as
char(10)
character set WIN1252) AS OR1252
from TBL_ORDER WHERE ORDERNUMMER='1481351-1'


The CREATE PROCEDURE with introducer syntax approcach fails,

See Error:

*** IBPP::SQLException ***
Context: Statement::Prepare(
ALTER PROCEDURE TEST
RETURNS (OR1252 varchar(10) character set WIN1252 )
AS
DECLARE ORUNI varchar(10) character set UNICODE_FSS;
BEGIN
for select ORDERREFERENTIE from TBL_ORDER WHERE ORDERNUMMER='1481351-
1'
into :ORUNI do
begin
OR1252 = Cast ( (_UNICODE_FSS ORUNI ) as varchar(10));
SUSPEND;
end

END )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 10, char 32
ORUNI


Regards,
Derryck