SQL Server Performance Forum – Threads Archive
parsing address
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| apt16You 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
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Satya – what can you mean?
http://www.sqldts.com/default.aspx?234
http://www.sqldts.com/default.aspx?205 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
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>
12 north plaza boulevard apt.16 i want to split the address and put it into multiple fields.
address_number
12 suffixA
North street_name
plaza blvd suffixb
apt16
anyone can help?
Read about Parsename in sql server help file Madhivanan Failing to plan is Planning to fail
]]>