Query to get the values after 3rd

Last Post 14 Jun 2011 08:15 PM by russellb. 6 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
vinoth
New Member
New Member

--
13 Jun 2011 06:35 AM
Query to get the values after 3rd character
'VinothKumar;Chennai;company;Asp.Net;SQLServer'

Query needed.


Regards
Vino
gunneyk
New Member
New Member

--
13 Jun 2011 09:27 AM
Can you be more specific? Have you tried looking at the string functions in BooksOnLine?
vinoth
New Member
New Member

--
13 Jun 2011 10:09 AM
'vinothkumar,company,asp.net,sqlserver'

in that i need to get the output after three character

Output will be like this :

othkumar,company,asp.net,sqlserver

Query needed.

Regards
Vino
rm
New Member
New Member

--
13 Jun 2011 11:24 AM
Can use substring for that, books online has syntax and samples.
vinoth
New Member
New Member

--
13 Jun 2011 08:44 PM
For single rows we can use the substring.

eg:
i am having 10 rows
In that i need to get the output after 3rd character.
How to do , Query needed.


Regards
Vino
gunneyk
New Member
New Member

--
14 Jun 2011 04:10 AM
You can certainly use substring in a query. People here are certainly more than willing to help when you have problems but we can't write all your tsql for you. You need to get a book or take a class on TSQL and use BooksOnLine to answer basic questions like this.
russellb
New Member
New Member

--
14 Jun 2011 08:15 PM
See this http://msdn.microsoft.com/en-us/lib...81984.aspx for what rm and gunney are talking about.


Acceptable Use Policy
---