Click here to Skip to main content
15,906,816 members
Home / Discussions / Database
   

Database

 
AnswerRe: retrieving column's data Pin
thatraja23-Oct-10 0:27
professionalthatraja23-Oct-10 0:27 
GeneralRe: retrieving column's data Pin
siang_wu_id23-Oct-10 0:35
siang_wu_id23-Oct-10 0:35 
AnswerRe: retrieving column's data Pin
thatraja23-Oct-10 0:46
professionalthatraja23-Oct-10 0:46 
GeneralRe: retrieving column's data Pin
siang_wu_id23-Oct-10 0:55
siang_wu_id23-Oct-10 0:55 
GeneralRe: retrieving column's data Pin
thatraja23-Oct-10 1:19
professionalthatraja23-Oct-10 1:19 
GeneralRe: retrieving column's data Pin
siang_wu_id23-Oct-10 1:37
siang_wu_id23-Oct-10 1:37 
GeneralRe: retrieving column's data Pin
thatraja23-Oct-10 1:47
professionalthatraja23-Oct-10 1:47 
AnswerRe: retrieving column's data Pin
RyanEK24-Oct-10 11:47
RyanEK24-Oct-10 11:47 
Hi,

I suggest you create a split function

CREATE FUNCTION [dbo].[Split]
(  
  @delimited nvarchar(max),  
  @delimiter nvarchar(100)) 
  RETURNS @t TABLE
(  
  id int identity(1,1),   
  val nvarchar(max))AS
BEGIN
  declare @xml xml  
  set @xml = N'<root><r>' + replace(@delimited,@delimiter,'</r><r>') + '</r></root>'

  insert into @t(val)  
  select     
    r.value('.','varchar(15)') as item  
  from @xml.nodes('//root/r') as records(r)  

  RETURN
END


Then cross apply to return your desired column. eg.

declare @tmp table (value varchar(100))
insert into @tmp values ('ASD654-100-CCCEEE4444-200-')
insert into @tmp values ('QWEQWEQ-2000-JJJLLL-20-PPPBBMMNN-600-')

select val 
from @tmp
cross apply dbo.split(value,'-')
where id = 3


Ryan
QuestionSQL Server 2008 - Number Manipulation Pin
ac01121-Oct-10 6:59
ac01121-Oct-10 6:59 
AnswerRe: SQL Server 2008 - Number Manipulation Pin
Eddy Vluggen21-Oct-10 10:05
professionalEddy Vluggen21-Oct-10 10:05 
AnswerRe: SQL Server 2008 - Number Manipulation Pin
RyanEK21-Oct-10 14:39
RyanEK21-Oct-10 14:39 
GeneralRe: SQL Server 2008 - Number Manipulation Pin
ac01121-Oct-10 23:07
ac01121-Oct-10 23:07 
QuestionUpdate query does not affects matched Pin
Abdul-Rhman Alsri21-Oct-10 5:28
Abdul-Rhman Alsri21-Oct-10 5:28 
AnswerRe: Update query does not affects matched Pin
Eddy Vluggen21-Oct-10 10:02
professionalEddy Vluggen21-Oct-10 10:02 
QuestionStored Procedure Pin
Nath20-Oct-10 22:19
Nath20-Oct-10 22:19 
AnswerRe: Stored Procedure Pin
J4amieC20-Oct-10 23:38
J4amieC20-Oct-10 23:38 
GeneralRe: Stored Procedure Pin
Mycroft Holmes21-Oct-10 13:04
professionalMycroft Holmes21-Oct-10 13:04 
GeneralRe: Stored Procedure Pin
J4amieC21-Oct-10 21:48
J4amieC21-Oct-10 21:48 
GeneralRe: Stored Procedure Pin
Mycroft Holmes22-Oct-10 0:52
professionalMycroft Holmes22-Oct-10 0:52 
QuestionReturn name and identity for all tables Pin
yippiecoder20-Oct-10 10:55
yippiecoder20-Oct-10 10:55 
AnswerRe: Return name and identity for all tables Pin
Blue_Boy20-Oct-10 21:12
Blue_Boy20-Oct-10 21:12 
GeneralRe: Return name and identity for all tables Pin
David Skelly20-Oct-10 22:40
David Skelly20-Oct-10 22:40 
QuestionI want your help Pin
Lamis Radman19-Oct-10 9:31
Lamis Radman19-Oct-10 9:31 
AnswerRe: I want your help Pin
Pete O'Hanlon20-Oct-10 0:02
mvePete O'Hanlon20-Oct-10 0:02 
QuestionXml datatype vs cdc Pin
Ebube19-Oct-10 6:47
Ebube19-Oct-10 6:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.