Hi Alvin,
The SQL statement you posted is invalid because subquery doesn't have FROM clause. It's also not clear what are you trying to do.
>Hi,
>
>I'm trying to update a column in a table like this.
>
>UPDATE TurnTimeTable
>SET TurnTime = (SELECT (DATECOMPLETE - DATESTART) as 'Turn Time'
>WHERE EmployeeID NOT LIKE '5%' AND EmployeeID NOT LIKE '9%'
>)
>
>
>Is there a way to do this without getting this error..
>
>Server: Msg 512, Level 16, State 1, Line 1
>Subquery returned more than 1 value.
>This is not permitted when the subquery follows =,
>!=, <, <= , >, >= or when the subquery is used as an expression.
>The statement has been terminated.
>
--sb--