Posted by Mr.Mime on 05/31/06 15:18
Hi to all.
Excuse my bad english but I have a problem with a query.
I have a table with a colum with datas formatted like this:
name//surname
For example:
ID | INFO
1 | George//Bush
2 | Silvio//Berlusconi
What I need is a SELECT with an order by the surname. In the example it
must return
2 and than 1 because Berlusconi is lower than Bush.
I think a regular expression will be fit for this task but I don't know
how to use it.
I'm using PostGre SQL with allow subSelection.
Thanks to all for any help.
Navigation:
[Reply to this message]
|