On Tue, Aug 12, 2003 at 02:32:00PM +0800, Ariz Jacinto wrote: > i've created a simple UDF (for testing) that returns a string. > my problem is that the string that it returns, contain some > of the characters of the longest string in the column. > > example: > > Table > +-----------------+ > | name | > +-----------------+ > | hello world | > | goodbye | > +-----------------+ > > > mysql> select echo(name) from table; > > hello world > goodbyerld <---- ??? > > *How do i fix this???
Maybe you can post the code and we'll help you fix it. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 10 days, processed 348,503,188 queries (383/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]