* Ennio-Sr <[EMAIL PROTECTED]> [040507, 23:52]: > * Jose Blanco <[EMAIL PROTECTED]> [040507, 14:28]: > > This second time I did, see > > > > select author, sort_author from itemsbyauthor where sort_author like 'tan%' > > order by 2; > > > Hi Jose, > have you tried to modify your query as others suggested? i.e.: > > --> select author, sort_author from itemsbyauthor where sort_author like > 'tan%' ORDER BY sort_author; > ^^^^^^^^^^^^^^^^^^^^
Oops ... I missed your "order by 2" ... Sorry ;( -- [Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?// Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°) [Why use Win$ozz (I say) if ... "even a fool can do that. )=( Do something you aren't good at!" (as Henry Miller used to say) ] ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster