>CONVERT(char(5), mydatefield, 8) seems to be just the ticket.
>
>Thanks,
>Mike
>
>PS CONVERT is T-SQL, not ANSI SQL, right? I'll have to find another way if the data is in Oracle?

Yes, you are right. If I remember correctly, Oracle has Format function with similar fuctionality.