function that returns a date from a string

• james marriot

  Mr or Mrs. 500

  Points: 563

  More actions

  August 10, 2006 at 8:12 am

  #115025

  i have a table full of months as strings.

   

  is there a function that could return a date of the first day of that month?

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  August 10, 2006 at 9:27 am

  #654349

  Ryan Randall's solution:

  select cast('1 ' + 'February, 2004' as datetime)

   

• james marriot

  Mr or Mrs. 500

  Points: 563

  More actions

  August 10, 2006 at 9:34 am

  #654355

  works like a charm.

   

  Thank you