I would like to change this statement so that it can concatenate 2 fields. The "Last Name" is currently being displayed as a drop down on a web form. I would like to concatenate it with "FirstName" and display a column ...

Hi all, I am performing insert and retrieve on sql server database. The insert is working fine but during retrieve, I get the following error: The data types text and varchar are incompatible in the equal to operator the error is ...