Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to call the first word character..

Author  Topic 

ejoeyz_85
Yak Posting Veteran

54 Posts

Posted - 2008-03-25 : 14:44:59

This is example... JANUARY.. i juz want to call JAN only..
anyone help me... is there any command to execute only JAN character??

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-25 : 14:52:49
SELECT LEFT('JANUARY',3)
Go to Top of Page

ejoeyz_85
Yak Posting Veteran

54 Posts

Posted - 2008-03-25 : 15:09:52
tq visakh16....
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-25 : 15:17:54
You're welcome
Go to Top of Page
   

- Advertisement -