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 |
|
oracle_corrgi
Yak Posting Veteran
98 Posts |
 Posted - 2006-10-10 : 02:57:23
|
| hihow do i validate address say i have coladdr1= 'sanjaynagar 3 main 4 main blore karnataka india'it is updated tocoladdr1 = 'jayanagr 10main blore kar india'i need to validate the textpls help methanxsdatabase |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-10 : 03:01:08
|
| You have to use a lot of REPLACE update statements.Not sure what you mean1) How is sanjaynagar updated to jayanagr2) How is 3 main 4 main updated to 10main3) How is karnataka updated to karPeter LarssonHelsingborg, Sweden |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-10-10 : 04:44:03
|
| do you have somthing called as zip code or po box in the seperate table where the extact address is specified.then you can validate the user inputs against that look table ??Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-10 : 09:58:05
|
| >>i need to validate the textDefine the term ValidationMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
validate address