I started SQL recently as a beginner i came across the above problem. the book i referring is using MySQL and i want to know how can i do the following in SQL Server
This is the query as per the example in the book
SELECT SUBSTRING_INDEX(location, ',', 1) FROM my_contacts;
Thanks in Advance
There is no equivalent function in SQL Server. We need to write our own function.
The below link would help you to do so:
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?