help in query

Hi,

i have a table which is supposed to give customer_id to each person who joins on the internet

the customerid should be autogenerated each time
the customerid is in this fashion

05-01-18-001

(05 is the year,01 is the month,18 is the day)
the last three digits are auto incremented numbers

so if there are 5 members who join on the 18th january 2005 it will be

05-01-18-001
05-01-18-002
05-01-18-003
05-01-18-004
05-01-18-005

now a new member joins on the 19th january 2005 it will be

05-01-19-001
05-01-19-002
05-01-19-003
05-01-19-004
05-01-19-005
05-01-19-006
05-01-19-007


can someone tell me how to do this in sql

thanks,

sam

Don't crosspost.