I have a table column with format like Camera/2012/6 (string/year/month). I would like to make a query to seperate with / character like
select string as field1, year as field2, month as field3 from theTable
The string part may contaon a space, eg. "Other Stuff/2011/11"
How should I do it? I'm using SQL Server 2005. Thanks.