SQL String

[stevelibby]

Is it possible to split a sql query string and include if then else and depending on the answer add to the string?

[TheNige]

Are you creating dymanic SQL or using stored procedures. You can create any kind of SQL string that you want. Can you give an example of the type of query you want to write?

[sgietz]

Sure you can. A SQL query is treated like any other string. That gives you enormous flexibility.

Please post example of what you want to do.

[Ossifer]

Another option would be to have multiple connection strings in the web.config and use the if then else logic to select the one you want.