Special Date/Interger Question

[nutrotek]

Hello,

I know how to take these two fields:
DateValue, 01/01/2007 and IntValue, 10 and create one field: 010107-10

REPLACE(CONVERT (VARCHAR(8), DateValue, 1), '/', '') + N'-' + CAST(IntValue AS VARCHAR(3))

How to I reverse the process, turn 010107-10 into 01/01/2007 and 10?

 

[rac2]

The position of the dash is

CHARINDEX('-', '010107-10')

CHARINDEX returns 7.

The first string is

SUBSTRING('010107-10', 1, (CHARINDEX('-', '010107-10')-1)  )

The second string is

SUBSTRING('010107-10', (CHARINDEX('-', '010107-10')+1), DATALENGTH('010107-10'))

Let @strDate be the first string. Then

SELECT CAST(@strDate AS DATETIME)
SELECT CONVERT(VARCHAR(20), CAST(@strDate AS DATETIME), 101)

will get you there.