DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: string processing help

Threaded View

  1. #3
    Join Date
    Feb 2002
    Posts
    267
    Excellent ebrain.
    Thx.

    Just wondering if this can be modified for variable columns.

    Like i have string length varying.


    For eg.,
    i have strings of columns 2,3 and 4

    eg
    data1;data2;data3,data01;;data03
    data1;data2,dataA;dataB

    If some data is missing then it will be blank. like.,
    data1;;data2
    But each string will have fixed number of columns.
    ie.,
    3;3;3,3;3;3
    2;2,2;2

    Instead of writing 3 different queries, can i modify the existing one.
    Last edited by Sonia; 07-29-2010 at 09:33 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width