Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    17

    Unanswered: How to Include a Forward Slash on a column value in Select Statement

    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

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    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(||)

  3. #3
    Join Date
    Sep 2010
    Posts
    17

    It worked

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •