Maxim Demenko wrote:
> barthome1_at_comcast.net schrieb:
>>
>>
>> So now I need to find a way to take the ORACLE GUID format and convert
>> it to the SQLServer format within a SQL select statement.
> That may be very difficult task if one consider lack of string
> manipulation functions in Oracle... ( no LEFT, no RIGHT, no MIDDLE)
SUBSTR() should be plenty enough. All '-' positions are fixed for GUUID.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html
Received on Mon Dec 18 2006 - 13:21:35 CST
