Re: How to do this

Frank van Bortel wrote:
> sjoshi schreef:
> >
> > Ok this time I tried using the _ option by specifying 2 character
> > before the O and that worked.
> >
> > 1 Select UTL_RAW.CAST_TO_VARCHAR2(S.OBJECTMONIKER) FROM CORESITE S
> > Where
> > 2* UTL_RAW.CAST_TO_VARCHAR2(S.OBJECTMONIKER) LIKE '__O%'
> > SQL> /
> >
> > UTL_RAW.CAST_TO_VARCHAR2(S.OBJECTMONIKER)
> > --------------------------------------------------------------------------------
> > % O L E _ S E R V E R % \ C r o s s S e c t i o n s \ C . s y m
> >
> > Does that make sense ?
> >
>
> Does that perhaps mean the first three characters are not:
> percent-space-capitalO?
> (You do realize the underscore character is a single
> position wildcard?)
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

Yes that's why I used it to see what was happening. Also ASCII function reports 37,0, 79 for first three so what looks ok. Now the string value in ADO.NET comes as

%\0O\0L\0E\0_\0S\0E\0R\0V\0E\0R\0%\0\\\0C\0r\0o\0s\0s\0S\0e\0c\0t\0i\0o\0n\0s\0\\\0C\0.\0s\0y\0m\0\0\0

When I do a DataReader.GetString(ColnName). ? Why is that ?

thanks
Sunit Received on Mon Oct 02 2006 - 15:04:44 CDT