BUG: Error 403: UNKNOWN TOKEN on SELECT with Subquery

WORKAROUND

• Use CASE...IS NOT NULL Transact-SQL statements, as shown in the following example:
  

        SELECT T1.title_id,
            pubid=
  
        CASE
  
        WHEN
        (select T3.pub_id from publishers T3
        where T3.pub_id = T1.pub_id and
        T3.pub_id = T2.pub_id)
  
        IS NOT NULL THEN
  
        (select T3.pub_id from publishers T3
        where T3.pub_id = T1.pub_id and
        T3.pub_id = T2.pub_id)
  
        WHEN
        (select T3.pub_id from publishers T3
        where T3.pub_id = T1.pub_id and
        T3.pub_id = T2.pub_id)
  
        IS NOT NULL THEN
  
        (select T3.pub_id from publishers T3
        where T3.pub_id = T1.pub_id and
        T3.pub_id = T2.pub_id)
  
        ELSE
        'BU1032'
  
        END
  
        FROM Titles T1, Titles T2
        WHERE T1.title_id =  'BU1032'
   
  						

  
  -OR-
• Use the convert function to tell SQL Server that the result of the subselect is the same type as the assignment column.
  
  For example, you can use a query similar to the following the following:
  

     SELECT   T1.title_id,
     pubid = COALESCE(convert(varchar,(select T3.pub_id from publishers T3
        where T3.pub_id = T1.pub_id and
        T3.pub_id = T2.pub_id)),
        'BU1032')
     FROM Titles T1, Titles T2
        WHERE T1.title_id =  'BU1032'