Regular expression date

[User 8328982]

How to convert "Jan DD" to "DD/01" where D is any digit from 0 to 9 (e.g.: Jan 15>15/01)

[George Jonsson]

Which programming language are you using? The regex engines might differ.

[nagshead_obx]

Select Case Month
When 1 Then 'Jan'
When 2 Then 'Feb'
When 3 Then 'Mar'
When 4 Then 'Apr'
When 5 Then 'May'
When 6 Then 'Jun'
When 7 Then 'Jul'
When 8 Then 'Aug'
When 9 Then 'Sep'
When 10 Then 'Oct'
When 11 Then 'Nov'
When 12 Then 'Dec'
End + '/' + CAST(Day as varchar(2))
From TableName

[George Jonsson]

So you want to do this in SQL?