Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by MikeyJinPhx
-
how do i build a dynamic where clause in a stored procedure?
Hi All, Just for the heck of it you might like to take a peek here. Pretty much Everything You Ever Wanted To Know About Dynamic SQL But Were (or weren't in this case!) Afraid To Ask... http://www.sommarskog.se/dynamic_sql.html Mike- MikeyJinPhx
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Problem using IN clause
Thx for the reply Jay! Your solution works great although in a moment of revelation I stumbled upon an alternative solution as well. UPDATE MyTable SET Field1 = 'blah', Field2 = 'blah' WHERE LEFT(Zip,3) in ('852','853','854','855') Is there any reason that one of these solutions might be more...- MikeyJinPhx
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Problem using IN clause
Hi All, Trying to update certain fields where their zipcode falls within a comma delimited list containing the FIRST THREE characters of the zip. Ex. '852,853,854,855' I'd assume it's something like this: UPDATE MyTable SET Field1 = 'blah', Field2 = 'blah' WHERE Zip in ('852,853,854,855') My...- MikeyJinPhx
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
