Re: [GENERAL] Ordering in SELECT statement

2007-06-26 Thread PFC
On Jun 26, 2007, at 14:41 , [EMAIL PROTECTED] wrote: and what I need is the following ("old fashion", that is, the "SPACE" is another character whose ASCII value is before any other LATIN letter's!!) AB CD AB EF ABAB ABD E What you don't want : peufeu=> SELECT column1 FROM (VALU

Re: [GENERAL] Ordering in SELECT statement

2007-06-26 Thread Michael Glaesemann
On Jun 26, 2007, at 14:41 , [EMAIL PROTECTED] wrote: and what I need is the following ("old fashion", that is, the "SPACE" is another character whose ASCII value is before any other LATIN letter's!!) AB CD AB EF ABAB ABD E Sorting is defined by the locale settings of your computer. I get

Re: [GENERAL] Ordering in SELECT statement

2007-06-26 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Hello, I use the following command "SELECT * FROM employees ORDER BY name" (a very simple sql statement) the main thing here is that I get a list ordered without taking into accound the spaces. For example, I get the following listing: ABAB AB CD ABD E

[GENERAL] Ordering in SELECT statement

2007-06-26 Thread [EMAIL PROTECTED]
Hello, I use the following command "SELECT * FROM employees ORDER BY name" (a very simple sql statement) the main thing here is that I get a list ordered without taking into accound the spaces. For example, I get the following listing: ABAB AB  CD ABD  E AB  EF and what