Posted by Toby A Inkster on 03/18/07 23:06

bill wrote:

> ORDER BY REPLACE(kennel_name,'The ','')
>
> What I want to do now is ignore "The " and "A " in a select, ie:
> replace both "The " and "A " with "".

ORDER BY REPLACE(REPLACE(kennel_name,'The ',''),'A ','')

You might also want to include "An " on your list.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!

[Back to original message]