I am upsizing an access DB to SQL. <BR><BR>I am currently re-writing some queries which are used to format data which is downloaded from another system.<BR><BR>The only problem is that not all of the fields are downloaded every time. In access this isn&#039;t a problem as a text box pops up titled &#039;Enter parameter value&#039; and the query will still run. However in SQL when creating a view, if the field is not present in the DB it causes an error.<BR><BR>Is there any way of saying use this field only if present? Or something like that?<BR><BR>Thanks