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 |
|
OMB
Yak Posting Veteran
88 Posts |
 Posted - 2001-06-13 : 12:42:12
|
| i have the following cod ethat i am using:update barcode set borrower_type = '1' from barcode, ##progs where ##progs.student_id = barcode.student_id and ((##progs.aos_code like '11%')or (##progs.aos_code like '12%') or (##progs.aos_code like '13%') or (##progs.aos_code like '14%')) and ((##progs.attend_mode = '01') or (##progs.attend_mode is null))is their an easier way to write the where part of the statement, instead of writing out'##progs.attend_mode = n' for every criteria. the next update has 10 different combinations.Thanxs |
|
|
|
|
|
Is their a better way!