Look at the substring example here http://dev.mysql.com/doc/mysql/en/string-functions.html
Regards, Reinhart Viane -----Oorspronkelijk bericht----- Van: shaun thornburgh [mailto:[EMAIL PROTECTED] Verzonden: woensdag 11 mei 2005 13:30 Aan: mysql@lists.mysql.com Onderwerp: Remove 1st 3 Chars Hi, is it possible to alter fields in a column by removing the first three characters? i.e. change 100123456789 to 123456789 Thanks for your help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
