How to return data without deliminators?

• Biank

  Ten Centuries

  Points: 1332

  More actions

  November 6, 2006 at 12:08 am

  #192999

  Hi all,

  I'm trying to return data from a table that contains data as following format;

  1,2,3,4,5... and so on up to 15 numbers.

  Is there any way to write a sql to get just numbers only without ,?

  Thanks for your help.

   

• faizjmc

  SSC Eights!

  Points: 881

  More actions

  November 6, 2006 at 12:21 am

  #669986

  Do u need like 1234567891011........15 or u want to manipulate each and every number.

  If its 2nd,then make use of while loop by checking the length of the returned string

   

• Vladan

  SSC-Insane

  Points: 22072

  More actions

  November 6, 2006 at 1:08 am

  #669987

  Hi,

  If you need to extract values from a comma delimited list, read this - some nice methods and evaluation of performance there.

  http://www.sommarskog.se/arrays-in-sql.html