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.

[Back to original message]