Hi, I've to order by q query by a column. SELECT a.id, a.nom FROM table a ORDER BY a.nom; And i've something strange. It's order like that: 5 | aaaa 8 | aaab 15 | ** aaac 6 | aaad I've "**" before the name in order to display them at first, but the 2 chars "**" are ignored in the order by. Can anyone explain me why ? PS: Sorry for my bad english, i'm french. -- phazon ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/