|visits||member for||3 years, 10 months|
Building Dynamic SQL-Server Where Clause
If you are building dynamic where clause for searching the data based on user input I highly recommend the article Dynamic Search Conditions in T-SQL by Erland Sommarskog
Does SQL Server Compact Edition 4 finally support Views?
@Uwe - If you need portable database, SQLite supports views