Re: How to handle a "the"
| From: | Digital Hit Entertainment | Date: | Wed, 05 Jul 2000 16:11:37 +0000 |
| Subject: | Re: How to handle a "the" | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-877@lists.php.net to get a copy of this message | ||
Jerry wrote:
> You would use the "replace" command to do that in the 'select' statement.
>
> select title, award, replace(title, "The ","") as sortedtitle from
> AwardList order by sortedtitle
Thanks to you and the others for these suggestions. I'll wrap my brain
round 'em and see which way to go.
--
Ian Evans