Another SQL question

[Charisma Bypass]

Right then ...

Customers table. 
Row is customers_number

Customers Info table
Pertinent rows are; customers_id and customers_info_date_account_created

What I have to do is:

get part of the customers_info_date_account_created and all of the customers_id and mix them up, then insert the result in the customers_number

Thus:

customers_id = 1441
customers_info_date_account_created = 2009-04-21 12:22:01

I need to get the parts in bold and insert them like this;

091441 into the customers_number (customers_info)

Any help would be very much appreciated.  Thank You in advance.

[MattC]

I don't know the full solution but this might help

http://doc.ddart.net/mssql/sql70/da-db_8.htm

[Jeep Stone]

You need to CONCATenate the customer_id with the YEAR() of customers_info_date_account_created, so something like this pseudo code:

INSERT INTO customersinfo (customers_numner) VALUES (SELECT CONCAT(YEAR(customers_info_date_account_created), customers_id))

[JasonD]

You need DATE_FORMAT if you want a two digit year, and you probably want some zero padding to the customers_id, so

INSERT INTO customersinfo (customers_numner) VALUES (SELECT CONCAT(DATE_FORMAT(customers_info_date_account_created, '%y'), LPAD(customers_id, 4, '0')))

Replace 4 with however many digits the id can go up to.

[Charisma Bypass]

Thank you guys, you set me on the right track.