InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 22:29:24 GMT20http://www.sqlservercentral.com/Forums/Topic1394865-391-1.aspxOops I got it... Have googled itThanku so much againMon, 10 Dec 2012 21:38:33 GMTprathibha_aviatorhttp://www.sqlservercentral.com/Forums/Topic1394865-391-1.aspxAwesome I got my output..But can u explain me ur code...I haven't come across charindex before... What does it do???Mon, 10 Dec 2012 21:36:17 GMTprathibha_aviatorhttp://www.sqlservercentral.com/Forums/Topic1394865-391-1.aspx[quote][b]prathibha_aviator (12/10/2012)[/b][hr]Women Art Revolution (2010)"!Next?" (1994)"#1 Single" (2006)"#ByMySide" (2012)"#Follow" (2011)"#nitTWITS" (2011)"$#*! My Dad Says" (2010)"$1,000,000 Chance of a Lifetime" (1986)"$100 Makeover" (2010)"$100 Taxi Ride" (2001)"$100,000 Name That Tune" (1984) Above mentioned is the movie column in my table GenresI just want to take the year i.e, (YYYY) at the end of each field. I used the code belowupdate [Genres] set Movie = SUBSTRING([Movie],0,FINDSTRING ([Movie],"(",1))-1And the folllowing errorMsg 195, Level 15, State 10, Line 1'FINDSTRING' is not a recognized built-in function name.:crying:[/quote]Try the following:[code="sql"]update [Genres] set Movie = SUBSTRING([Movie],1,CHARINDEX('(', [Movie]) - 1)[/code]Mon, 10 Dec 2012 21:30:23 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1394865-391-1.aspxWomen Art Revolution (2010)"!Next?" (1994)"#1 Single" (2006)"#ByMySide" (2012)"#Follow" (2011)"#nitTWITS" (2011)"$#*! My Dad Says" (2010)"$1,000,000 Chance of a Lifetime" (1986)"$100 Makeover" (2010)"$100 Taxi Ride" (2001)"$100,000 Name That Tune" (1984) Above mentioned is the movie column in my table GenresI just want to take the year i.e, (YYYY) at the end of each field. I used the code belowupdate [Genres] set Movie = SUBSTRING([Movie],0,FINDSTRING ([Movie],"(",1))-1And the folllowing errorMsg 195, Level 15, State 10, Line 1'FINDSTRING' is not a recognized built-in function name.:crying:Mon, 10 Dec 2012 20:50:34 GMTprathibha_aviator