Database

[MSSQL]CASE WHEN THEN

애플자라 2012. 1. 8. 14:02
반응형

SELECT
 A +' ' + B
 + CASE WHEN ISNULL(C,'') = '' THEN ' ' ELSE ' / ' END
 + D + CASE WHEN ISNULL(E,'') = '' THEN ' ' ELSE ' / ' END
 + F AS PERSON
FROM DUAL
반응형