Home Forums SQL Server 7,2000 T-SQL getting year from string RE: getting year from string

  • April 14, 2005 at 8:46 am

    #552726

    try this:

    SELECT substring(field,CHARINDEX('/', field)+1,4) from table