SQL Server Performance

parsing address

Discussion in 'SQL Server DTS-Related Questions' started by gongxia649, Aug 2, 2006.

  1. gongxia649 New Member

    hi, im running into a bit of a problem. i will like to string parse the street name into what you see below using DTS. How can i get around this?

    12 north plaza boulevard apt.16

    12|N|plaza blvd| apt16
  2. satya Moderator

    You can take help of GLobal variables in this case, refer to books online for more information.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. Adriaan New Member

    Satya - what can you mean?
  4. satya Moderator

  5. FrankKalis Moderator

    Since this is a DTS related question, I guess this is a better place for it. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>
  6. gongxia649 New Member

    12 north plaza boulevard apt.16

    i want to split the address and put it into multiple fields.


    plaza blvd


    anyone can help?
  7. Madhivanan Moderator

    Read about Parsename in sql server help file


    Failing to plan is Planning to fail

Share This Page