Sergio Samayoa wrote:
> What database?
> That not a standard SQL.
> Try CAST:
>
> select 'A' || CAST(' ' AS CHAR(90)) || 'A Z' as test from dual
1. CAST is not available in SAP DB
2. CHAR (90) --> 'Z' is part of MySQL (for example)
3. There is no function in SAP DB converting the ordinal number of a character
to its character representation
4. I never understood who will NEED (not only use) such a conversion, for
what kind of problem as it is very uncommon to ask for the ordinal
number of a character in a user input or something like that which
has to be converted back to its character representation
5. Maybe putting directly 'Z' instead of putting CHAR(90) in the statement or
a SUBSTR ('......ABCDE...Z...', 90,1) or a SUBSTR ('ABC..Z', :param - 64,1)
may help
Elke
SAP Labs Berlin
> -----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
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
