Re: Using hex string in where clause

Steve Rainbird wrote:
> I am trying to search for some information in a varchar2 column that has
> Arabic characters in it. Unfortunately I don't have an Arabic keyboard.
>
> Is there a way of easily doing something like the following.
>
> where column like '%\xE3\xCD\xE3\xCF%"
>
> Where the \xE3 is hex E3
>
> TIA
I don't have enough experience to know if this will work but take a look at: http://www.psoug.org/reference/builtin_functions.html scroll down to ASCIISTR and UNISTR functions. Click on the icons.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org