InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 00:27:41 GMT20http://www.sqlservercentral.com/Forums/Topic565829-338-1.aspxThank you, that worked!Tue, 09 Sep 2008 10:36:38 GMTJody Claggett-376930http://www.sqlservercentral.com/Forums/Topic565829-338-1.aspxTo select just the month, that is data to the left of the first comma try this code to give you an idea of what you can do:DECLARE @FM as VARCHAR(10)DECLARE @Indata AS VARCHAR(20)SET @Indata = 'July, 2008'SET @FM = (SELECT(SUBSTRING(@Indata,1,(CHARINDEX(CHAR(44), @indata)-1))))PRINT 'For testing fiscal month is*' + @FM + '*'at this point the variable @FM contains what you want and you can then insert this into a column in a table, use the set statement in a function or use it as you wish.I included:PRINT 'For testing fiscal month is*' + @FM + '*'so that you can verify your results before using, of course in actual use you will not include the PRINT statementCHAR(44) is the ASCII comma.Mon, 08 Sep 2008 19:01:44 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic565829-338-1.aspxI have a set of data that gives me month name and year in this format:FiscalMonthJuly, 2008August, 2008September, 2008I need to select only the month name part of the string, so everything from the comma to the right needs to be excluded. I tried searching for a forum subject on this, but couldn't find anything. If there is another post with information on this, please let me know.Thank you.Mon, 08 Sep 2008 16:34:38 GMTJody Claggett-376930