SEO

#1 (**permalink**) 03-01-2008, 11:52 AM

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?

#2 (**permalink**) 03-01-2008, 11:52 AM

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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

string function