Home Forums SQL Server 7,2000 T-SQL getting year from string RE: getting year from string
alkrup-104967
SSC Enthusiast
Points: 147
More actions
April 14, 2005 at 8:46 am
#552726
try this:
SELECT substring(field,CHARINDEX('/', field)+1,4) from table