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 |
|
sanjnep
Posting Yak Master
191 Posts |
 Posted - 2008-05-05 : 12:58:00
|
| Hi All,How to find if , if more than 1 on string?Like Address...........Maidenhead, Berkshire, No SL6-3QHQueretaro, 7680222451-041 Rio de Janeiro, RJ,Neyork city, 900789Xing City,Petthity,Thaui90..................................I need only....................Address...........Maidenhead, Berkshire, No SL6-3QH22451-041 Rio de Janeiro, RJ,Xing City,Petthity,Thaui90 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-05 : 13:04:20
|
| SELECT Address FROM YourTable WHERE LEN(Address)-LEN(REPLACE(Address,','.''))>1 |
 |
|
|
|
|
|
|
|
Finding total character on string