COALESCE( dim_Study_Type.classical_intelerad_study_description, '' ) AS Classical_Intelerad_Study_Description,
下面是我得到的一些结果:
-CT HEAD WO
CHEST SINGLE VIEW
-XR CHEST
CT ANGIOGRAPHY
-CTA HEAD
我如何修剪或删除'-'时,他们存在?
如果它是起始字符,则可以使用ltrim
select ltrim(COALESCE( dim_Study_Type.classical_intelerad_study_description, '' ),'-')
,
select ltrim('-ab-cd-', '-');
ltrim
--------
ab-cd-
(1 row)