Hi, I need do the follow:
Table 1. Field 1. Varchar (6) Field 2. Varchar (6) The data in this table are for example Field 1 Field 2 A TT A YY A RR B FF B KK I need to obtain a result in the following form: A TTYYRR B FFKK How can i do this? Thanks for any help! Javier Javier Diaz IT Developer *** This message has been scanned for all known viruses by MessageLabs. This message is intended for the stated recipients only and may be confidential. Opinions expressed in this email do not necessarily reflect the opinions of Globepost Travel or Travelselect.com. If you feel you received this email in error and would not like receive any further emails from travelselect.com, please reply to [EMAIL PROTECTED] *** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php