creo que te falta un parentesis cerca del like...
Código SQL:
Ver originalSELECT RXFAM1, RXFAM2, RXFAM3, PSPREC, VMVNNM FROM (SELECT RXFAM1, RXFAM2, RXFAM3, RXFAM4, PSPREC, VMVNNM, ROW_NUMBER() OVER (ORDER BY CASE WHEN @marc = 'ok' THEN VMVNNM END ASC, CASE WHEN @prc = 'desc' THEN PSPREC END DESC, CASE WHEN @prc = 'asc' THEN PSPREC END ASC) AS Recursos FROM Recursos WHERE CPA01 LIKE [B]([/B]@clave + '%') AS Resultados WHERE Recursos BETWEEN 8 * @PageNumber + 1 AND 8 * (@PageNumber + 1)
prueba y comentas :)