Posted by Erland Sommarskog on 12/19/06 23:01

TGEAR (ted_gear@hotmail.com) writes:
> select distinct(f.agency+y.year+s.type) as SDNF
>
> In this select clause, I try to use the last 2 digit of year for y.year
> value. which function should i apply to it?

substring if year is a string value. There is an entry in Books Online
in the T-SQL Reference for "Functions". Looking through that entry may
be well spent time.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]