Hi,
Column named Birth_MM_DD has values stored as 0807(mmdd), not sure of the data type of the column(doesn't look like a date field). When retrieving the values from the Birth_MM_DD column, i want to include a forward slash seperating the month & date - ex: 08/07..... what function to use in sql?
help please!
Han

There are many ways(functions) to include slash.

If the data type of Birth_MM_DD was CHAR(4), some examples:
1) INSERT
2) TRANSLATE
3) SUBSTRs(or LEFT and RIGHT) then concatenate(||)

It worked, great....... muchos gracias!