Using hex string in where clause

From: Steve Rainbird <news.nospam_at_rainbird.me.nospam.uk>
Date: Thu, 4 Jan 2007 14:31:44 -0000
Message-ID: <504he7F1dihk7U1_at_mid.individual.net>

[Quoted] [Quoted] 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

-- 
Steve

Received on Thu Jan 04 2007 - 15:31:44 CET