>Hi >how can i replace, in a SELECT query, the last 3 numbers with asterisks? >from 0123456789 to 0123456***
My psudocode for this would be something like: Select CONCAT(left$(`field`,(LENGTH(a)-3),'***') >From `table` But there might be more efficient ideas out there. -------------------------------------------------------- This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]