case when ayuda

[flaviovich]

Has probado asi:

Código SQL:

SELECT a.IdUsuario,
CASE WHEN CONTAINS(a.Des,'PEPE') AND CONTAINS(b.Des,'P') THEN 1 ELSE 0 END
FROM FOREMAN a
INNER JOIN ADEMAN b ON a.Id = b.Id