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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-23 : 09:32:27
|
| Filipe writes "I have to do a SP that parses the address in two like this example:We have: 1 field called address address: "Av de Portugal, nº 20"Now i want to parse it in two: address_1 : Av de Portugal address_2 : nº 20The problem comes when i have also these examples:"Av de Portugal nº 20""Av de Portugal 20""Av de Portugal, nº 20 - A""Av de Portugal, 20 - A"etc ...Attetion: the address is not always the same. i used only for this example.Can you help ?" |
|
|
|
|
|
parse string