Hi, what will be proper way for below statement to avoid heavy load/statement on SQL:-

 SELECT * FROM table1 where field1="123" or field1="246" or
       field1="157" ....

- if i might have 100 selection on field1 then the statement will be very long, what should i do eliminate it.
- if i wish to use sqlparameter associate in the above statement ,what should be do.

TQ

you can use between...and...syntax if your values are continuous. On the other hand you can use field1 in (val1, val2,...valn) syntax.

for parameters,use have to use EXEC statement.