Connecting Tech Pros Worldwide Help | Site Map

ordering text field with non-alphanumerical character

  #1  
Old November 23rd, 2005, 03:04 AM
Hugo Coolens
Guest
 
Posts: n/a
I want to order a text field which contains some words which begin with
a single quote, if however I perform the following query, the single
quote seems to be neglected:

select arabic, dutch from woordenlijst order by arabic;

After this query the words are ordered as if there _wasn't_ a single
quote in the beginning.
e.g. I get:
'arn eeuw
arrajul de man
'ashal gemakkelijker


How can I make a list of words with all text field values which start
with a single quote grouped together.
e.g.:
'arn
'ashal
arrajul

p.s.
you may wonder why I use words starting with a single quote, it is just a
standard approacht to transcribe the arabic character hamza that way


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ordering python sets Mr.SpOOn answers 20 November 6th, 2008 01:35 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 09:56 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 03:15 AM
PEP 350: Codetags Micah Elliott answers 20 October 1st, 2005 01:55 AM
ordering field containin non alpha numeric character Hugo Coolens answers 0 July 19th, 2005 11:28 PM