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 |
|
kohlhaas77
Starting Member
25 Posts |
 Posted - 2008-08-01 : 11:52:04
|
| I need to select any addresses containing the phrase "PO Box".I am trying this:WHERE (Street LIKE 'PO Box')but it is not working.Please help! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-01 : 11:52:44
|
Street like '%PO Box%'
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-08-01 : 12:14:19
|
| ..or "P.O. Box", or "P. O. Box", or "P.O.B." or "POB" or "P O Box"...Have fun.e4 d5 xd5 Nf6 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-01 : 12:51:14
|
| alsoWHERE PATINDEX('%PO Box%',Street)>0 |
|
|
|
|
|
|
Address containing "PO Box"