Query to get the values after 3rd

Last Post 14 Jun 2011 09:15 PM by russellb. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
vinoth
New Member
New Member

--
13 Jun 2011 07: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 10: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 11: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 12:24 PM
Can use substring for that, books online has syntax and samples.
vinoth
New Member
New Member

--
13 Jun 2011 09: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 05: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 09:15 PM
See this http://msdn.microsoft.com/en-us/lib...81984.aspx for what rm and gunney are talking about.
You are not authorized to post a reply.

Acceptable Use Policy