What database?
That not a standard SQL.
Try CAST:
select 'A' || CAST(' ' AS CHAR(90)) || 'A Z' as test from dual
-----Mensaje original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Marcel
Honstra�
Enviado el: Martes, 08 de Julio de 2003 09:25 a.m.
Para: [EMAIL PROTECTED]
Asunto: Converting
Hi,
i want to do something like that:
SELECT 'A' || CHAR(90) || 'A Z' as TEST FROM DUAL
The problem is the CHAR(90). It works fine on other databases.
But what to do in SAPDB? Is there a function which does the same?
With Beste Regards
Marcel Honstra�
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
