yeah, that is what I did to fix it...just curious why the problem was
there in the first place.
On Wed, 02 Feb 2005 14:40:55 -0600, Martin Norland
<[EMAIL PROTECTED]> wrote:
> blackwater dev wrote:
> > Why is this query handled differently in 4.1?
> > 4.0
> > select lower(concat(last_name,id)) from client where prim_id=1
> > returns johnson1
> > 4.1
> > same query returns Johnson1
> > Why don't the lower work in 4.1 when you concatonate with a number?
> No idea.
> select concat(lower(last_name),id) from client where prim_id=1;
> - Martin Norland, Database / Web Developer, International Outreach x3257
> The opinion(s) contained within this email do not necessarily represent
> those of St. Jude Children's Research Hospital.
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php