Re: Using hex string in where clause

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1167928147.43472_at_bubbleator.drizzle.com...
> 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

Thanks Daniel

-- 
Steve