Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nghorakavi
Starting Member
3 Posts |
 Posted - 2007-11-16 : 17:03:16
|
| Hi I have to split the address of length Char(35) into Addr.Line1Addr.Line2for e.g 1400 HIGHVIEW COURT 1400 will go in Line1 and rest in Line2.I have lot of scenarios, some are starting with PO box and apartment numbers.Can any one tell me what would be the SQL query to tackle this scnearios, IF any one can suggest me how to do this?Thanks in advance.Narasimha. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2007-11-16 : 17:42:39
|
| Can you elaborate on the criteria to be used to split the addresses? As you mention, there are quite a few scenarios to be covered.=======================================The only man I know who behaves sensibly is my tailor; he takes my measurements anew each time he sees me. The rest go on with their old measurements and expect me to fit them. -George Bernard Shaw, writer, Nobel laureate (1856-1950) |
 |
|
|
|
|
|
Address splitup logic