View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:01 AM
=?ISO-8859-1?Q?Olav_M=F8rkrid?=
 
Posts: n/a
Default finding non-ascii characters within a string

hello

i would like to search a table column for a range of non-ascii
characters, or a particular non-ascii character. how can i do this?

the column can be any string like "hello, world" or "norwegian
characters זרו here".

refer to these pseudo examples:

SELECT * FROM TABLE WHERE COLUMN CONTAINS CHARACTERS BETWEEN 128 and 255;

SELECT * FROM TABLE WHERE COLUMN CONTAINS CHARACTER = 240;

thanks
Reply With Quote