Re: How to do this

sjoshi wrote:
> 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

Never, ever, rely on an implicit conversion. And I'd very much appreciate the link to the page that you refer to so that I can have it corrected.

Thank you.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group