Stripping out first 4 characters in text string

Hi Experts,

This should be an easy one for you SQL people.  I have a text string that I'm bringing into a SQL table where it looks like this:  "Tue 01/29/2008" (w/o quotes).  I would like to strip out the first 4 characters so that during the import process (via SQL Integration Services), it sees just "01/29/2008" thus being able to save the data in a datetime format.  How would the T-SQL look?
pedrok00Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
SELECT RIGHT ('Tue 01/29/2008', LEN('Tue 01/29/2008')-4)
0
 
pedrok00Author Commented:
Never underestimate my ability to not see the obvious.  Thank you aneeshattingal.
0
All Courses

From novice to tech pro — start learning today.