[talvanor]

Hello,
I am fairly new to Oracle and SQL statements, our DBA has moved on and I have to fill in the role till we replace him. I have a job that i need to calculate a file name with a date in the name. Basically the filename needs to be

ACH1017 where 1017 is the current date, I have had luck with this statement formatting the date the way I want

select to_char(sysdate,'mmdd') from dual

but how do I concat the ACH at the beginning so the end result is

ACH1017?

Thanks

[buckeye234]

select 'ACH'||to_char(sysdate,'mmdd') from dual

[talvanor]

That was exactly what I needed and it works great!!

Thanks for the fast reply.

Jeff