How to do this

From: sjoshi <sjoshi_at_ingr.com>
Date: 1 Oct 2006 17:41:31 -0700
Message-ID: <1159749691.284996.249010@m73g2000cwd.googlegroups.com>

Hello All

For SQLServer I could cast the ObjectMoniker coln which is of varbinary type to nvarchar to see if it's got the %OLE% string like in

cast(S.ObjectMoniker as nvarchar(100)) like '%OLE%'

How do I do this for Oracle ? In this case it is of type RAW(256). The doc.says that there is Implicit Conversion to char type but I'm getting only numbers when I try this :

Select S.ObjectMoniker From CORESite S

If I add the Where Clause, I get 0 rows

Where S.ObjectMoniker Like '%OLE%'

thanks
Sunit Received on Sun Oct 01 2006 - 19:41:31 CDT