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
반응형