Database

zead wrote:

i know that

zead wrote:

in another database the property is exist

SELECT SUBSTRING([ColumnName],12,10) FROM [Table]

thatraja |Chennai|India|

---

Tips/Tricks|Brainbench certifications

Do what you want quickly because the Doomsday on 2012

siang_wu_id wrote:

that code was very hard to understand

siang_wu_id wrote:

i'm still a newbie here.
but thanks alot friend. it helps and i'll try...

thatraja |Chennai|India|

---

Tips/Tricks|Brainbench certifications

Do what you want quickly because the Doomsday on 2012

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

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

ac011 wrote:

Basically, the first digit is transfered to the 3rd position on the right side.

• Cast the column to a VARCHAR
  
• Reararrange the characters using the string-functions described here[^]
  

I are Troll

<br />
declare @value varchar(11)<br />
set @value = cast(12345678 as varchar)<br />
select cast(substring(stuff(@value, len(@value)-1, 0, substring(@value,1,1)), 2, len(@value)) as int)<br />