.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

SQL HELP

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
 

Hi all,

I have the following:

1/2009
12/2009
3/2009

I would like to get only the 1, 12 and 3...but i dont know how to do that..

if i do SELECT left('1/2009',1) it works for this example..but not for this SELECT left('12/2009', 1) it gets one were i need 12, i could put 2 instead of 1 but in my query i wont know what is 12 or 1...please help me




View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend